Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I would like to be able to have an IF function within a measure that will enable me to call another measure if it is before today and another if it is after today. Is it possible to do this and if so how?
The logic essentially is = if( Calander[Date] <= Today() , Cumulative Sum , Forecast )
Any help will be appreciated.
Regards,
Shaun
Solved! Go to Solution.
if( max(Calander[Date]) < Today() , [Cumulative Sum] ,[Forecast] )
Or
calculate([Cumulative Sum], filter(Calander, Calander[Date] < Today() )) + calculate([Forecast] , filter(Calander, Calander[Date] >= Today() ))
if( max(Calander[Date]) < Today() , [Cumulative Sum] ,[Forecast] )
Or
calculate([Cumulative Sum], filter(Calander, Calander[Date] < Today() )) + calculate([Forecast] , filter(Calander, Calander[Date] >= Today() ))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |