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 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

 

 

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.

     

     

2 Replies

  • 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?