Forum Discussion

norken20's avatar
norken20
Helper I
6 years ago
Solved

YTD FUNCTION

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 be...
Need Help
Show and Tell
Tips and Tricks
  • Gelgarico's avatar
    Gelgarico
    6 years ago

    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.

     

     
Gelgarico's avatar
Gelgarico
Regular Visitor
6 years ago

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's avatar
    norken20
    Helper I
    6 years ago
    Spoiler
    Formula for Fiscal Date.

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