Calculate Month on Month, Day on Day, Year on Year using DAX // Beginners Guide to Power BI in 2021

  Рет қаралды 41,740

Fernan

Fernan

Күн бұрын

Пікірлер: 29
@thrivingchaos
@thrivingchaos Жыл бұрын
You sir just put an end to my 3h of searching for a video/article that will explain in detail how is this achieved! Thank you so so much!!
@marquaieteutsch5800
@marquaieteutsch5800 Ай бұрын
I love your videos, very helpful. Thanks for helping me make my dashes the best they can be!
@Tammy-o9q
@Tammy-o9q 4 ай бұрын
Thank you for sharing! Your video and explanation helped me so much.
@olufemisanchez9773
@olufemisanchez9773 2 жыл бұрын
Great video, what about if I want to compare % change of 3 months interval. For instance % change between July and September
@SolutionsAbroad
@SolutionsAbroad 2 жыл бұрын
Thanks for watching! In this case you'll probably need a different solution, you can try this one I covered recently which uses DATESINPERIOD kzbin.info/www/bejne/lYa5kIOdqbCbjc0
@ahmedalshehabi7925
@ahmedalshehabi7925 2 жыл бұрын
How can you compare Month to Date (MTD) vs. Last Month to Date (LMTD) where the reflection and visualization of data shall be based on the current date TODAY(). Thanks.
@SolutionsAbroad
@SolutionsAbroad 2 жыл бұрын
This is really interesting Ahmed, I will cover it in a video as I'm also curious what this would look like!
@luismitu8858
@luismitu8858 7 ай бұрын
Thanks, it helped me a lot!
@rahamatmadarangi
@rahamatmadarangi Жыл бұрын
Great video, Is there a way we can see Pervious year data and next to that we see the current year data
@rajatsehgal4249
@rajatsehgal4249 9 ай бұрын
While entering DAX function which key you press for moving to next line .
@akwasidanquahakwaboah4666
@akwasidanquahakwaboah4666 2 ай бұрын
use shift and enter key. I faced the same problem
@insertnamehere8625
@insertnamehere8625 10 ай бұрын
there is literally a Quick Measure to do this built into Power Bi.
@vijayvizzu1
@vijayvizzu1 3 жыл бұрын
Nice video, how can we restrict it use only single year, though I have selected a single year as 2021 in the slicer, but still Jan 2021 compares the values with Dec 2020. Is there a way to restrict only selected year ? Jan 2021 should be blank
@SolutionsAbroad
@SolutionsAbroad 3 жыл бұрын
Hi Vijay, it sounds like you'll need to wrap the whole measure with IF(NOT(ISBLANK(), [Measure here])) This makes sure any rows without any values will be excluded
@vijaydahake4388
@vijaydahake4388 4 ай бұрын
Hi, nice session. What happens when i drill up the MoM to see Data on X axis with Months or vice-versa
@bzflowerbee
@bzflowerbee 2 жыл бұрын
This is just what I needed but my situation is I want to compare current year monthly to last year monthly and shows the difference in percentage. I can't use 'previousmonth', what should I use to get the previous year monthly? Thanks for your help as always.
@deeswift-z1h
@deeswift-z1h 8 ай бұрын
do we need the dates from calendar table or can I get it from my fact tbale itself ? As, I have data till march but its comparing for April as well and summing it to 0 (for MOM comparison )
@DineshGodge
@DineshGodge Жыл бұрын
Hello There, Its explained very well.Thanks Actually I am having Query that if i have 2 years data i want to show that MOM value for first month of each year should be same as actual but in my case it is taking =YTD value of Previous Year (2022)- January 2023 = giving wrong result it must take January 2023 as it is when i select year 2023 and also for 2022 Could please help on the same. if required more details please let me know
@sooryaprakashverma6044
@sooryaprakashverma6044 5 ай бұрын
I am calculating the previous month sales and difference comparing with current and previous month but I get blank values in the column. How it is possible? This previousmonth function is not working for me.
@sziganmo
@sziganmo 2 жыл бұрын
Hello, I have a questions regaring Day on Day fuction - i understand why BLANKs showed up but is there any way that if we don't have a data from PreviousDay our measuer will take next No Blank value? Btw thanks for your videos that was a milestone for me :)
@SolutionsAbroad
@SolutionsAbroad 2 жыл бұрын
Hi there, of course! For this case, you'll need to use the IF statement to check if the value is empty, then show blank (or usually ZERO)
@alfreddowuona-owoo9936
@alfreddowuona-owoo9936 2 жыл бұрын
Please how will you do that for a week on week change? Weekday starts from Monday
@safirahvandermeer5129
@safirahvandermeer5129 Жыл бұрын
I just have one metric I want to do this for so example; I don't use 'quantity x price', but just 'quantity'. However, I did these steps for one metric (used SUM instead of SUMX ) which works to mimic the same values as the original 'quantity' values, however next step with 'last month' calculation does not work (no values are shown). Tips anyone?
@DineshGodge
@DineshGodge Жыл бұрын
Hi Sir, Here if we select current year (2021) then it shows current month (Jan 2021) minus previous month (Dec 2022). but i want to show that if i select current year it will show same value for 1st month that is Jan 2021 without previous month value? can you tell us how to do it? if anyone here knows it they can help me thanks in advance
@dnwatson2
@dnwatson2 3 жыл бұрын
What about the Month compared to last year's same month?
@SolutionsAbroad
@SolutionsAbroad 3 жыл бұрын
Hi there, there is a DAX function called PARALLELPERIOD that will allow you to do this: docs.microsoft.com/en-us/dax/parallelperiod-function-dax
@thambiswamy9281
@thambiswamy9281 2 жыл бұрын
please provide files also
@SolutionsAbroad
@SolutionsAbroad 2 жыл бұрын
Hi Thambi, the files are all available to download through my Patreon: www.patreon.com/posts/demo-files-52538104
Calculate Growth over Last Year by Fiscal Year in Power BI
18:00
Turn Off the Vacum And Sit Back and Laugh 🤣
00:34
SKITSFUL
Рет қаралды 11 МЛН
Mom Hack for Cooking Solo with a Little One! 🍳👶
00:15
5-Minute Crafts HOUSE
Рет қаралды 18 МЛН
The evil clown plays a prank on the angel
00:39
超人夫妇
Рет қаралды 43 МЛН
Don’t Choose The Wrong Box 😱
00:41
Topper Guild
Рет қаралды 50 МЛН
🚨 YOU'RE VISUALIZING YOUR DATA WRONG. And Here's Why...
17:11
Adam Finer - Learn BI Online
Рет қаралды 254 М.
How to create month over month Analysis Chart in Power BI
11:04
Achievers Data Engineering
Рет қаралды 64 М.
Calculate Delta in Power BI: YoY Revenue (Year over Year)
15:20
PowerBI with Bogdan
Рет қаралды 138
How to use Microsoft Power BI - Tutorial for Beginners
27:53
Kevin Stratvert
Рет қаралды 4,2 МЛН
This Year VS Last Year Time Comparisons & Differences In Power BI
9:21
Turn Off the Vacum And Sit Back and Laugh 🤣
00:34
SKITSFUL
Рет қаралды 11 МЛН