Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

DAX Compare N number of days across Months

I have a date slicer that generally is used for MTD.  For example my slicer shows March 1st - March 20th and a have a single bar on a bar graph that shows the number of widgets sold for that time period.  What I need to add is the number of widgets sold Feb. 1st - Feb 20th as a bar, Jan1st- Jan20th as a bar and so on for the 12 previous months.


I would need this to change based on the selection of the slicer, so if I change it to Mar 1st - Mar 25th the other data points would adjust for 1st-25th in their respective months.


How would I go about accomplishing this???  Any and all suggestions are welcome.

Frequent Visitor

I have solved my problem using the below video by @parry2k :


This solution worked perfectly for my need.

View solution in original post

Super User
Super User

@noircrk glad to hear that my youtube video helped to solve your problem. Thanks!

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Frequent Visitor

I have solved my problem using the below video by @parry2k :


This solution worked perfectly for my need.

Super User
Super User

MTD = VAR _year=2008 VAR _month=3 VAR _day=31 RETURN CALCULATE(TOTALMTD([Sales Amount],'Date'[Date]),FILTER('Date','Date'[Month Number]<=_month&&DAY('Date'[Date])<=_day&&'Date'[Calendar Year Number]=_year))

Thank you @wdx223_Daniel !  Could you help me understand what it is this formula does?  Variables for Year, Month and Day I wouldn't think would be hardcoded with values and I don't see any mentions of getting the prior months data.


When I adapt this to my data the result is empty.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors