Forum Discussion
Dynamic latest load variable for Full Year forecast
I have a table I'm showing which has several lines, all of which are measures including Actual Sales YTD and Forecast Sales Full Year. The data is loaded right after the end of the previous quarter ...
Figured it out! changed the latest_forecast variable to match the load date quarter -1 selected value on the slicer and added the extra filter within the CALCULATE
Figured it out! changed the latest_forecast variable to match the load date quarter -1 selected value on the slicer and added the extra filter within the CALCULATE