Forum Discussion

ahawk's avatar
ahawk
Regular Visitor
1 year ago
Solved

Help with Clustered Column Chart

Hello,

 

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

Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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!

2 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    1 year ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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!