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
I've created YTD in the following period 01/01 --> 10/27 with the following formula, but I'm having trouble with incorporating the sameperiodlastyear formula in it:
Actual YTD ($) = TOTALYTD (sum(f_sales[Actual ($)]) ; d_time[calender_date] ; DATESBETWEEN(d_time[calender_date] ; "01/01";"10/27"))
I've also postet a picture, since it's easier to see
I appreciate any ideas of how to get the same periodlastyear
Thanks in advance
Solved! Go to Solution.
I got it to work with Calculate instead of TOTALYTD. Not sure what the difference is, but it works 🙂
Thanks for the help
Try wrapping Datesbetween with sameperiodlastyear
For some reason. it's not possible to have both the sameperiodlastyear and datesbetween in the same formula 😞
Br
Pastrupgaard
Remove the last bracket please
I see a Red ")" in the image you posted
My bad 🙂
I've corrected the formula, but there is no data output... I've recreated the data with a stupid workaround (so i know the data is there) and now i'm trying to make it smarter with this formula.
Any smart ideas?
Br
Pastrupgaard
I got it to work with Calculate instead of TOTALYTD. Not sure what the difference is, but it works 🙂
Thanks for the help
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 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |