Forum Discussion

cyborgandy's avatar
cyborgandy
Helper II
2 years ago

Previous Year All Month Data Display

Hi All,   In the below snapshot the above graph is only showing  data for Jan and Feb of previous year, however I want this to show month on month trend of previous year and not only for selected p...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi cyborgandy ,

The function you used in the DAX formula does move the date by one year, but to make sure it captures the entire range of months in the previous year, we need to make sure that the context in which it is evaluated includes all the months in that year. Here's an improved method:

External Previous Year = 
CALCULATE(
    [External Total Count],
    FILTER(
        ALL('Calendar Date'),
        YEAR('Calendar Date'[Date]) = YEAR(MAX('Calendar Date'[Date])) - 1
    )
)

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

cyborgandy's avatar
cyborgandy
Helper II
2 years ago

Hi thanks you for your response, but this DAX is giving me the cumlative number of entire year in all the months however I want momnth on month count to be diplayed for last year and not the cumlative