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 Guys,
What I'm trying to do as a measure to work in a table and probably charts too.
=IF(Month >= Month(Today()), Year = Year(Today()), 'Show Measure with new calculated figures','show historic sales' (Sales)
So
Jun : Jul : Aug
10 : 15 : 20
Sales field : Sales Field : Calculated measure.
Thanks
Solved! Go to Solution.
I gave up waiting and worked it out lol, just need to add the Year bit in, which i'll sort out easily.
Measure 3 = if([Measure 2]>= MONTH(TODAY()),[Measure 2],[Measure 4])
I gave up waiting and worked it out lol, just need to add the Year bit in, which i'll sort out easily.
Measure 3 = if([Measure 2]>= MONTH(TODAY()),[Measure 2],[Measure 4])
Measure = IF([Month]>MONTH(TODAY()) && [Year]=YEAR(TODAY()); [Calculated measure]; [Historic sales] )
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |