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.
Hello everyone,
I need your help with my YTD formula:
YTD = CALCULATE(TOTALREVENUES[salesdata]; DATESBETWEEN(salesdata[date_processed]
; DATE( year(MAX(salesdata[date_processed])); 1;1)
; DATE( year(MAX(salesdata[date_processed])); month(lastdate(all(salesdata[date_processed]))); day(LASTDATE(all(salesdata[date_processed]))))))
The below formula was working for me last year but since this year, the formula is comparing 5th january 2018 with 4th of january 2017 while 5-1-2018 is on a friday and 4-1-2017 is on a wednesday.
Can anyone please help me?
Cheers,
In your scenario, as you said that your YTD formula is comparing 2018-1-5 with 2017-1-4. Then what’s wrong with it? What’s your expected result?
I’m not quite understand about your requirement. Please elaborate your issue by sharing us more information like some sample data and your desired output. Otherwise, we can only make a guess.
By the way, to calculate the YTD value. I don’t think you need to specify such complicate formula. Please refer to TOTALYTD Function.
Thanks,
Xi Jin.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |