Forum Discussion
Create table from measure - Help please!
From my data, I have the values for Actual and Forecast which I can easily slice them to week or month, depending of the view I select on my field parameter slicer. Now my challenge - I need to recr...
There is not enough information here to help, but if power query is ruled out as solution then creating a computed table is not going to help either, beceause your computed table will not be taking into account any filter or slicer in your report.
Adding meausures to calculate cummulative values is not to hard, and you'll find many examples for that. The only requirement is that yoiu have a proper date dimension linked to your actuals and forecast (fact) tables.