Month over Month Calculation in Power BI using DAX
Vložit
- čas přidán 30. 05. 2021
- When working with dates, one of the common types of analysis is period vs period, such as Year over year, and Month over month. In this article and video, I'll explain how you can use DAX to write calculations for month-over-month simply in any Power BI report.
download the Power BI file and find the links to study more from my blog:
radacad.com/month-over-month-...
*******************
Want to learn about Power BI or AI? or take your Power BI and AI knowledge to the next level for building reports? Check out our courses in RADACAD Academy for all aspects of Power BI and AI.
RADACAD courses: radacad.academy
Our upcoming courses: learn.radacad.com/events/
Free books and tools for Power BI: radacad.com
Become an academy member: learn.radacad.com/academy/
*******************
********
CONNECT with US!
********
-- / radacad_com
-- / rad_reza
-- / leila_etaati
-- / radacad
-- / leila-etaati-b0304636
-- / rezarad
-- / 6393399
-- radacad.com
********
#PowerBI #PowerBIfromRookieToRockStar #PowerQuery #DAX #Visualization #RADACAD - Věda a technologie
Followed this today. Thank you. I managed to create what I needed to after following your guidance.
Love this, thank you very much for sharing, very insightful.
This worked for my scenario. Thanks a lot for this video.
Hi! Really useful! How could I built the same instead for one month for 6 months vs. the prior 6 months? Or if somebody wants to dynamically select how many months to compare to prior months?
This is really useful, thanks. I wonder if this could be used for future date calculations. for example where I want to see my budget for the next 6 months after the current month based on 10% of the total budget for example
Thank you so much
Hi Reza, thank you it was very useful. I can not find the link for another training video that you mentioned in the video, about the difference between the custom date table and the default date table? could you please provide the link, thank you.
How would you account for a situation where the previous period is a weekend day? How can you use the most recent Friday in the situation?
Thanks great video!
thanks sir
Has beautiful as this work looks like 👍 it seems to take an advance approach or say time is not spent on each concept & formula used. Please 🙏 Can you consider beginner in your video explanation next time thanks 😊
Thank you!!! Subscribed
Thanks for the sub!
Could you help how to set automatic change month on month percentage based on the date. Basically i need to know current month -1. Count vs month -1 calculation.
perfect
What if you are trying to use the calculate field based on a text field (not a number field like your example with sales)?
I have a question
In the table we have Display Id, cost bracket,Month name and year.
I need to display yes if any of the month contains blank in the present year with respect to display Id.
Any body have any idea please suggest me thanks in advance.
Hi. Please, how would you treat it if a month is blank? Example: january has 10 and february blank, with 5 for december. I would like to compare 10 for january with 5 for december (skipping the blank month)
Hi,i want to divide previous month sale with previous month num.can you please advise dax formula.thanks
Amazing content sir!! Just one thing; you didn't posted the link to the video or blog where talked about "Customer Date Table" vs the "Defaault Date Table" in Power Bi. Hope you can post it!
Is this possible too total bar as well each month in chart?
Could you please suggest in the same chart how to get the tool tip showing last year month ,Nov-2020 while hovering on right side bar should show as Nov-2020 and hovering on left side should show as Nov-2021. Right now both the bars while hovering are showing the same MMM-YYYY i.e Nov-2021 which is little confusing to the users
sry 9 months later , but did you find the solution plz, i have the same problem, thanks
Hi Reza , I'm a big fan of yours, I wanted to know that how to show weekly cumulative count with user relationships for actual sales untill today
Hi Manik
Thanks for kind words.
I have another video about Week-to-Date, check that out.
If you filter 1 month (current month), the LM will be gone.
Correct. this is because the FILTER CONTEXT in that case will be only a month, to change that, you'll need to add something to prevent it from happening, such as using ALL function or similar.