YTD FUNCTION

[norken20]

Hi,

May I seek for your help on how can I modify this PowerBI Graph where I need to show a straight line of the YTD sales. September is my start date and using the measure below the line graph below is what is showing. Is there any way I can modify this measure so that my TYD will reflect from September 2019 to August 2020? So a straight line will be showing instead.  Thank you

[Gelgarico · Accepted solution]

Hi @norken20 

In your case you need to add calendar table with equivalent modify date column (example: Sep 2019 = Jan 2020) since your date start Sep 2019 end to Aug 2020. YTD Function is automatically calculate base on the given date value.

[norken20]

Spoiler

Formula for Fiscal Date.

Understainding the logic your solution is correct but may I know your formula for FiscalDate?