Last 3 months by date based on selecting a different date field

[thhmez7]

Hello,

I've opened a similar thread, but this usecase is a bit enhanced:

An event can have multiple Accounts. Eve O has the accounts C and O. If I click this event, the chart should show the revenue of last 3 months (including current month), starting with March 2021 of the Account Date.

However here it shows only one month:

Here is my measure:

Measure

Relationships:

Relations

Account table with Revenue and Date

Event table 

Thank you for your help

[TomMartens · Accepted solution]

Hey @thhmez7 ,

I assume this article provides what you are looking for: https://helicaltech.com/display-selected-month-data-using-date-dimension-powerbi/

The essential part is using a dedicated calendar table.

Hopefully this provides what you are looking for.

Regards,

Tom

[thhmez7 · Accepted solution]

https://www.youtube.com/watch?v=d8Rm7dwM6gc&t=789s

found a solution in this video, thanks guys.

[Ashish_Mathur]

Hi,

See if my solution here helps - Flex a Pivot Table to show data for x months ended a certain user defined month.

[TomMartens · Accepted solution]

Hey @thhmez7 ,

I assume this article provides what you are looking for: https://helicaltech.com/display-selected-month-data-using-date-dimension-powerbi/

The essential part is using a dedicated calendar table.

Hopefully this provides what you are looking for.

Regards,

Tom

[thhmez7]

Hi @TomMartens 

I just tried this with a calendar table which has relation to Account table with Date column. However still not correct, as this shows only one month with the sum/cumulative value of the last 3 months. It should be spread over the last 3 months of the selected month. What could be still wrong?