Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
noircrk
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.

1 ACCEPTED SOLUTION
noircrk
Frequent Visitor

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

 

https://www.youtube.com/watch?v=UG1WxkBkM48

 

This solution worked perfectly for my need.

View solution in original post

4 REPLIES 4
parry2k
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.

noircrk
Frequent Visitor

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

 

https://www.youtube.com/watch?v=UG1WxkBkM48

 

This solution worked perfectly for my need.

wdx223_Daniel
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

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.