Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a bar chart showing revenue by month and a date slicer for the range. I would like to add another column for forecasted revenue but have the forecasted revenue be only for dates after the date range in the slicer.
Here is what I've attempted:
To get the max date from the slicer:
Max Date Value = MAXX( KEEPFILTERS(VALUES(DimDate[FullDate])), CALCULATE(MAX(DimDate[FullDate])) )
To get the forecasted amount for dates after the max date:
Forecasted Amount = CALCULATE( Forecast[Total Forecast Amount], FILTER(ALL(DimDate), DimDate[FullDate] > [Max Date Value]) )
Table currently (expecting to see forecasted amounts for april and may):
Hi PorterHaus,
Modify measure [Max Date Value] like below and try again:
Max Date Value = CALCULATE ( MAX ( DimDate[Fulldate] ), ALLSELECTED ( DimDate[Fulldate] ) )
Regards,
Jimmy Tao
Hi @v-yuta-msft,
Thank you for your reply. I updated the measure to match yours and nothing has changed. I think the problem is in the Forecasted Amount measure because I expect to see values after 3/30/18 but currently don't.
Thank you
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |