How to compare SAME PERIOD LAST MONTH in Power BI using DAX // Beginners Guide to Power BI

[@doubleseatvlogs]

It was really helpful.... thank a lot for sharing such real-life corporate requirements 🙂

[@winniedlaydy1013]

Exactly what i needed. Thanks Fernan... from Ghana....

[@Terniedintorni]

You are one of the best online. thanks

[@marceloenlaoficina2236]

Thank you so much for your videos !!

[@SolutionsAbroad]

Thanks for watching them!

[@BhanuYadav-wg2rs]

To the point video thanks a lot fernan❤

[@SivaKumar-fv6lk]

Thank you so much, very nice explanation.

[@aahadal]

Thank you

[@jiranansupawong7472]

Thanks

[@shivamsatija3318]

Hey, Great Video. But this dateadd function has a problem. Whenever, I select date from 21st Apr'22 - 30th Apr'22 for sum of sales, date add gives me a sum of values from 21st Mar'22 - 31st Mar'22 (End of month) Technically, I want to compare sales from 21st Apr'22 - 30th Apr'22 v/s 21st Mar'22 - 30th Mar'22 Can u please assist me a little here.

[@andrey_shch]

Thank you!!!

[@sitiauniamaram3422]

Thank you this help me alot. Is it possible to this manually other than using time intelligence function ?

[@LoNeGhEtTo]

Hi there, Jan has 31 days and Feb has 28, how do you deal with this with the SPLM? Wouldn't SPLM only compare data up to 28 Jan only instead of the entire Jan.

[@manishamanhas6162]

Hey can you pls make video of time intelligence functions interview questions for beginners

[@sleepy.1s]

Hello. I followed your calculations but im getting a different result. 1. MTD is not showing as cumulative. It just showing the same value of my sale column. 2. Previous Month is showing completely blank but there's a value in Total. It is the SUM of all months minus the latest month. I dont know whats wrong with my calculation. Please help!

[@bennaniyusuf6845]

how to create a slider that work for 3 charts should i combinate them with the date and hide the 2 date changer

[@phanvinh4501]

well, it doesn'twork if put it to a pivot table where ros are sales man and cols are some sales metrics like target, % achv and the col to see the ROLLING AMOUNT FOR THE SAME PERIOD LAST MONTH.

[@arnaudquirin2165]

Thank you this helped me a lot. I did the same thing from Jan to Apr however when I filter on specific period the figures in the column SPLM disappear. Any suggestion to tackle that ?

[@SolutionsAbroad]

Hi there, it's most likely because the filter context changes when you add a period filter to it. The easiest fix to this is to create the calculations as a new column, it's not the most elegant but it will fix your issue Hope it helps

[@jeffmiller4405]

How did you filter for the current month? My visual display is the same until I attempt to filter. I tried filter for the current month and tried filtering if the Prior Month value is greater than 0 and it keeps excluding the prior month line graph.

[@hoaithuongluu2869]

Great video, but as far as I know, dateadd will always pick a given period till the end of the month. Let's say if we chose a period in apr from apr 23 to apr 30 and computong same previous last month, the result is data in march but computing from mart 23 to mar 31 (not mar 30) is there any other solutions for this case ?

[@unitedwings7644]

Hey hi in powerbi I want to compare a value for continuous 15 mins if the value is same for 15mins continuously and I need a count 1 for that

[@francescomantovani3936]

Oh, yeah.

[@ramrajurkar4850]

Can u help me to create slicer for last day , last week/month/qtr/year

[@rephechaun]

Hi Fernan, these are great videos. Thank you very much. I wonder is there a way to do DATEMTD but on working day, instead of calendar day For example, suppose 1 Feb 2022 is the 1st working day of Feb, same period last month of 1 Feb 2022 >> should be 2 Jan 2022, because 1 Jan is a public holiday, hence 2 Jan is the 1st working day of last month Basically, I'm looking for a way to calculate Same period last month by working days.. Hope anyone can help me here..i'm really stuck

[@niko9bellic]

How can we avoid the -100%? Writing someting like " " or " - "

[@trishlasutaria7451]

Hello. Thank you for the video. It is helpful. I am seeing an issue with SPLM. If I apply the filter top 1 by the latest date I get a blank count on the card.

[@SolutionsAbroad]

Hi there, does the correct value show up if you put it on a table? Perhaps its a row context issue

[@gayatrilshinde1560]

How to solve this context issue

[@gayatrilshinde1560]

But it gives wrong total in total it gives mtd for whole year ..i want to show in card

[@Gua10ify]

thank you

[@felixgaince6303]

Thanks so much !

[@SolutionsAbroad]

You're welcome!