topic Re: Display Current Month Range and Compare it with Previous Month Range in DAX Commands and Tips

Display Current Month Range and Compare it with Previous Month Range

STV — Wed, 18 Feb 2026 18:00:38 GMT

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 (say DEC 2025).

Also, pick the dates from the Calendar icon as shown in the picture.

Any help is appreciated.

Thanks,

STV

Re: Display Current Month Range and Compare it with Previous Month Range

Irwan — Wed, 18 Feb 2026 23:43:48 GMT

hello STV

this is the best visual that i can do that match to your screenshot.

there is no dashboard as your screenshot so you need to have some work around.

1. create a measure for current month

Desc1 =
var _MinCal1 = EOMONTH(TODAY(),-1)+1
var _MaxCal1 = EOMONTH(TODAY(),0)
Return
_MinCal1&" - "&_MaxCal1

2. create a measure for selected slicer date

Desc2 =
var _MinCal2 = MIN('Calendar 2'[Date])
var _MaxCal2 = MAX('Calendar 2'[Date])
Return
"Compared with: "&_MinCal2&" - "&_MaxCal2

3. get a rectangular shape, then under Style option, go to text then conditional formating.

4. in text conditional formating, choose Field value under Format style, then use the measure for current month.

5. do the exact for the selected slicer date.

Hope this will help.

Thank you.

Re: Display Current Month Range and Compare it with Previous Month Range

STV — Thu, 19 Feb 2026 14:43:15 GMT

Irwan - Thanks a bunch for your help. It gave some idea on how to use the conditional formatting.

Couple of questions:

1.How are you able to display that tiny calendar icons

2. How did you use both Desc1 and Desc2 in one rectangle shape.

Sorry for the silly questions.

Re: Display Current Month Range and Compare it with Previous Month Range

Irwan — Thu, 19 Feb 2026 22:36:21 GMT

hello STV

1. that is a between date slicer but if you resize small enough, it will show a between date without the slider

2. that are two rectangular shape, each shape for one measure. because as far as my knowledge, concatenate command in pbi can not create a new line like alt+enter in excel, so we need to create two shape and place side-by-side.

Hope this will help.

Thank you.

Re: Display Current Month Range and Compare it with Previous Month Range

techies — Sat, 21 Feb 2026 06:47:36 GMT

Hi STV should the current vs previous month range appear as a header summary like this example?

Re: Display Current Month Range and Compare it with Previous Month Range

v-saisrao-msft — Mon, 23 Feb 2026 03:55:32 GMT

Hi STV,

Have you had a chance to review the solution we shared by Irwan techies? If the issue persists, feel free to reply so we can help further.

Thank you.

Re: Display Current Month Range and Compare it with Previous Month Range

STV — Tue, 24 Feb 2026 15:11:49 GMT

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!

Re: Display Current Month Range and Compare it with Previous Month Range

v-saisrao-msft — Wed, 25 Feb 2026 06:07:01 GMT

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.

Re: Display Current Month Range and Compare it with Previous Month Range

v-saisrao-msft — Mon, 02 Mar 2026 04:14:53 GMT

HI STV,

Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.

Thank you.