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 have created a YTD measure using the below formula. But when I put them in the grid. Its showing the same result for Splitter Amount as well as for the Amount YTD. Could you please help me here throwing some lights on what would have gone wrong?
Amount YTD = CALCULATE(('Sales'[Splitter Amount]), DATESYTD('Calendar'[CLDR_DT]))
Hi @Anonymous,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Regards,
Daniel He
Hi @Anonymous,
Could you please post me some sample data and your desired result?
Regards,
Daniel He
Hi,
I have created a YTD measure using the below formula. But when I put them in the grid. Its showing the same result for Splitter Amount as well as for the Amount YTD. Could you please help me here throwing some lights on what would have gone wrong?
Amount YTD = CALCULATE(('Sales'[Splitter Amount]), DATESYTD('Calendar'[CLDR_DT]))
This is what your basic YTD Measure should look like.
YTD Measure = CALCULATE ( [measure], DATESYTD ( 'Date'[Date] ) )
It seems you are referencing a naked column. So just add the appropriate aggregation function.
Amount YTD = CALCULATE (
SUM ( 'Sales'[Splitter Amount] ),
DATESYTD ( 'Calendar'[CLDR_DT] )
)
Hope this helps!
This is what your basic YTD Measure should look like.
YTD Measure = CALCULATE ( [measure], DATESYTD ( 'Date'[Date] ) )
It seems you are referencing a naked column. So just add the appropriate aggregation function.
Amount YTD = CALCULATE (
SUM ( 'Sales'[Splitter Amount] ),
DATESYTD ( 'Calendar'[CLDR_DT] )
)
Hope this helps!
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 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |