Forum Discussion

STV's avatar
STV
Frequent Visitor
8 months ago
Solved

Display Current Month Range and Compare it with Previous Month Range

  Team, The below snapshot picture is the new requirement which I need to display on my dashboard. Basically, I need to display the current month (say JAN 2026) and Compared with: previous month (...
  • v-saisrao-msft's avatar
    v-saisrao-msft
    7 months ago

    Hi STV,

    Thank you Irwan, techies, for your insights.

    You can achieve this in Power BI by using a standard date slicer for custom date selection, together with a disconnected comparison table and DAX measures to calculate the previous equivalent period dynamically. I’ve set up this method to provide flexible date selection and automatic previous-period comparison, and I’ve attached the PBIX file for your reference.

     

    Thank you.

STV's avatar
STV
Frequent Visitor
7 months ago

Hi v-saisrao-msft, 

Unfortunetly, the issue is still open. to be more specific, her is how it should look like when I click on the Calendar icon and would be able to select my own dates from the last month period. Appreciate your help.

 

 

Thanks!

v-saisrao-msft's avatar
v-saisrao-msft
Icon for Community Support rankCommunity Support
7 months ago

Hi STV,

Thank you Irwan, techies, for your insights.

You can achieve this in Power BI by using a standard date slicer for custom date selection, together with a disconnected comparison table and DAX measures to calculate the previous equivalent period dynamically. I’ve set up this method to provide flexible date selection and automatic previous-period comparison, and I’ve attached the PBIX file for your reference.

 

Thank you.