Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello Everyone,
I have an issue where my fical year is calculated incorrectly due to our fiscal year starting 10/1/2019 and ending 9/30/2020.
I have a measure that is calcluating Actual (This Period), which is as follows:
Solved! Go to Solution.
Total ytd can take year end
Actual (YTD) = TOTALYTD([Actual (TP)],'Date'[date],"9/30")
Actual (LYTD) = TOTALYTD([Actual (TP)],dateadd('Date'[date],-1,year),"9/30")
These are some datesytd example
YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(('Date'[Date]),"9/30"))
This Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD((ENDOFYEAR('Date'[Date])),"12/319/30"))
Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"9/30"))
Last YTD complete Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR(dateadd('Date'[Date],-1,Year)),"9/30"))
Last to last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-2,Year),"9/30"))
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))
Total ytd can take year end
Actual (YTD) = TOTALYTD([Actual (TP)],'Date'[date],"9/30")
Actual (LYTD) = TOTALYTD([Actual (TP)],dateadd('Date'[date],-1,year),"9/30")
These are some datesytd example
YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(('Date'[Date]),"9/30"))
This Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD((ENDOFYEAR('Date'[Date])),"12/319/30"))
Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"9/30"))
Last YTD complete Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR(dateadd('Date'[Date],-1,Year)),"9/30"))
Last to last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-2,Year),"9/30"))
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))
Can I have similar syntax for QTD(Sep,Oct,Nov-Q1....) and HYTD(Sep,Oct,Nov,Dec,Jan,Feb,Mar-HYTD) (Fiscal Year starts from Sep-Aug)
Thank you, I wasnt aware of that formula and it worked perfectly!