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
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
Remove the last bracket please
I see a Red ")" in the image you posted
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?
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.