Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Total YTD does not work

I have a table which I use to override a SUM measurement. This works fine in overriding the Sum measurement. However when I apply DATESYTD function on this measurement, I get incorrect results. My mo...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 
Let me know if this works
 
Measure = CALCULATE (
    [#New Term Policy],
    FILTER (
        ALL ( Calendar ),
        'Calendar'[Date]
            <= MAX ( 'Calendar'[Date] )
            && YEAR ( 'Calendar'[Date] )
                = YEAR (
                    MAX ( 'Calendar'[Date] )
                )
    )
)
 

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks for the suggestion. I got the same result. It is not working.

    Any other ideas?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Anonymous ,

       

      What i understand from your visual is taht Report Date is not part of the Date Table.

       

      You need to pull the Date from the Date table in the visualization.

       

      Regards,

      HN

       

      Can you share your model and some sample date in text format.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        It appears what is happening is Power BI is not letting 2 different Date relationship from 2 seperate table to exist in one YTD calculation.

         

        Does that make sense?