Help with Clustered Column Chart

[ahawk]

Hello,

Anyone know of a way to filter a clustered column chart to show only two months past a date?

[Anonymous · Accepted solution]

Hi @ahawk,

Thanks for the reply from  Ashish_Mathur.

If you just want to filter data two months ago, I think you could use the EDATE().

This is my sample data:

Create a measure and write the DAX as below:

SalesTwoMonthsAgo = 
CALCULATE(
    SUM('Table'[Amount]),
    'Table'[Date] >= EDATE(TODAY(), -2) && 'Table'[Date] < EDATE(TODAY(), -1)
)

I would be grateful if you could provide me with the pbix file or sample data.

The pbix file is attached.

If you have any other questions please feel free to contact me.

Best Regards,
Qi
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[Ashish_Mathur]

Hi,

Share some data to work with and show the expected result.  Share data in a format that can be pasted in an MS Excel file.