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've been searching many topics and videos but still can't fix my issue.
I need to show the the current fiscal year to date profit and previous fiscal year to DATE profit in a report.
for example, when I open the report on March 12th, I want to see the current Fiscal YTD profit and same period of last fiscal year YTD profit (to March 12, 2017)
here are the measures I've tried:
measure TFYTD GP = CALCULATE([Current Period GP],DATESYTD(DimDate[Date],"30/9"))
measure LFYTD GP = CALCULATE([measure TFYTD GP],DATEADD(DimDate[Date],-1, YEAR))
I also created another measure to compare...
Measure2 LFYTD GP = CALCULATE([measure TFYTD GP],SAMEPERIODLASTYEAR(DimDate[Date]))
and I got below result.
measure TFYTD GP is correct and gave me the correct number.
but both measure LFYTD GP & Measure2 LFYTD GP gave me the correct number on the day of March 12th, but i don't know why the total is incorrect. the number 159,999 is covering until end of March of 2017, but I only want to know the number until March 12th, 2017.
Not sure where is wrong and how to fix this issue.
thank you.
Solved! Go to Solution.
Hi @ericbi,
Here is a thread showing the similar scensrio as yours for your reference:
Best regards,
Yuliana Gu
Hi @ericbi,
Here is a thread showing the similar scensrio as yours for your reference:
Best regards,
Yuliana Gu
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |