Forum Discussion

jj6291's avatar
jj6291
Frequent Visitor
4 years ago
Solved

Filter forcasted dates based on slicer selections

I hae a dataset where we have forecasts of the price of something based on every day of the year. i.e the forecasted 2022 price based on the 3rd of march, now based on the 4th of march etc. The data...
Need Help
  • jj6291's avatar
    jj6291
    4 years ago

    Hi, thanks for the suggestion. I ended up doing something similar. I made a new table and set columns up for overlapping periods and then made a 3rd table where I unpivoted the data manually. I think it was a bit overkill

VijayP's avatar
VijayP
Community Champion
4 years ago

jj6291 

Use this formula 
IF(DateDim[Year]<SELECTEDVALUE([DATEDIM[Year]), BLANK(),
required measure for Forecast) let me know if that works . Else share the sample data without any classified information.