Forum Discussion

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

Create a Calendar Table.  Create a relationship (Many to One and Single) from the Date column of the Data Table to the Date column of the Calendar Table.  To your visual, drag the Date column from the Calendar Table.  This pattern should work

Total = sum(Data[Sales])

YTD sales = calculate([total],datesytd(calendar[date],"31/12")

Measure = if(min(calendar[date])>today(),[Total],[YTD sales])

Hope this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Ashish_Mathur ,

     

    Thank you for your response. I tried the way you suggested and created one calendar table from the date which needs to be taken as a refernce and created 3 measures as per your suggestion Total, YTD ,Measure however as soon i dragged the "Measure" column in the table its not giving me the correct result instead of this no of rows has been multiplied . 

    I need cumulative data untill today's date and if date is of future then data shoudl remain same for that date :

    Please see below :

    Solution which i am looking for is:

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      2 years ago

      Hi,

      I can help further only when i get access to the PBI file.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi,

        i am not sure how to share the pbix here as i dont see any option 😞

        Regards,

        Ashish