October 8, 2018 at 10:59 pm #10918
The error occurred because I used variables, which were introduced as a feature in Excel 2016.
Attached is workbook without variables.
Attachments:You must be logged in to view attached files.October 9, 2018 at 7:03 pm #10923
The lack of variables is definitely a huge missing positive. Thank-you for customizing the model. I will work through the formulas using Rob’s book as a reference, and get back to you if there is anything I can’t figure out.
AFOctober 9, 2018 at 9:11 pm #10924
Have you considered using Power BI Desktop? It is free, has the latest and greatest of all DAX features, and you can now even print its reports!
TomOctober 10, 2018 at 5:07 pm #10929
I experimented with Power BI desktop last year, and I found it was great for dashboards and reports where the final viewer is human. But a lot of what I’m doing (like this one) is interim analysis to be fed into a further spreadsheet, and I didn’t think that PowerBI could export spreadsheets like that?
AFOctober 10, 2018 at 8:16 pm #10931
Although the cost is minimal compared to other BI products, now you are no longer looking at only free solutions. Datasets loaded into Power BI in the cloud (develop in Power BI Desktop and publish to powerbi.com) can also be data sources.
There is also a much more advanced solution becoming available through Power BI: the Common Data Service.
With monthly, and sometimes weekly, updates to Power BI, the Power BI you knew a year ago has moved into bigger and better applications that the competition perhaps has already started to explore.
🙂October 11, 2018 at 4:13 pm #10933
Thanks for the info, Tom. I’ll have to take another look at Power BI and the Common Data Service.October 11, 2018 at 4:23 pm #10934
You must be logged in to reply to this topic.