I am coming to the end of project building a Management Accounting model Thanks to everyone at DNA who has helped me learn this software over the last 12 months!
We still have a requirement to pdf out reports to 3rd parties and to some of our staff who will not be licenced to use pbi. I have tried numerous methods (paginated reports, SSRS etc) and returned to exporting data from pbi desktop to excel. Whilst you pbi purists will be laughing now it works for me LOL!
My excel query is an evaluate - summarize columns thing which can and has been set up in pbi model, as a dax table. It takes a minute or so to build and builds everytime the model is refreshed.
I can run the DAX expression in excel, but sometimes run into memory issues, which does not happen building the static table in pbi.
Now to the question:
Is there a way of building that DAX table conditionally with a variable, true or false. - true build/false don;t build. Then I can switch the build off for most of the time and build it once a month when needed for XL export.
I tried this but i get the error “Expression refers to multiple columns. Multiple columns cannot be converted to a scalar value”.
So it seems SWITCH and IF only work with scalar values. grrrr!
Any assistance greatly appreciated.