Calculate Growth From Previous Non Consecutive Date
ฝัง
- เผยแพร่เมื่อ 5 ต.ค. 2024
- Fellas thanks so much for pouring in your answers. Here is the solution for anyone who needs more explanation.
---Download Files Here
goodly.co.in/g...
- - - My Courses - - - -
✔️ Mastering DAX in Power BI -
goodly.co.in/l...
✔️ Power Query Course-
goodly.co.in/l...
✔️ Master Excel Step by Step-
goodly.co.in/l...
✔️ Business Intelligence Dashboards-
goodly.co.in/l...
- - - Blog - - - -
www.goodly.co....
You are awesome in all aspects like communications, length of the video, presentations and DAX... Kudos bro!!!
Glad you like them!
helpful. got stuck in one calculation and this video helped to get the right way.. thanks
Thank you so much! I have been struggling with this for a week and you solved in 8:51 min. Subscribed!
Me too.
Hey Chandeep,
Impressive, I normally follow "Guys in A Cube" and "BI Elite", but you drag me to your channel through your presentation and skill.
Thanks Buddy to count me in the league! Hope you are having a good time on my channel.
Cheers
Wow really clear explanation that a beginner like me can quickly grasp, you’re a great teacher! Thanks for your help.
Glad it was helpful
You my friend just saved my ass in the nick of time!! I cannot thank you enough!
Thank you ! It really helped me to improve the logic.
Excellent explained! Step by step. Thumbs up for you!
Glad it was helpful!
Thanks a lot sr, ive been searching for this for a long time and finally i found how to do it!
I have another problem, it only works in a table, in a chart i have to quit the hierarchy in the x axis of dates in order to work, but in also quit some functionalities :c
SO HELPFUL, I LOVE YOUUUU
Wow very nice vedio, can you please help how to calculate Growth from End of previous year till date. your help would be highly appreciated.
This is awesome. How about adding on this tutorial what if there is a category column like Per Product and their daily sales growth?
My Source : PostgreSQL
Connection: Direct Mode
We have calculated
Days of forecast=
IF(
(OR(Source_Acticity[Count of movement Days] 'Date'[Total movement Days],
Source_Activity[Count of movement days])
Now I want calculate Missing days forecast in above pls how to calculate let me if possible try to make video it will helpful for me.
Sir, u r lessons r always great. Sir, pls help us to solve to show data when it changed, with current and last price
Solution worked great, but am having trouble because the results are blanked out when any granularity is added such as Previous Total Sales by product. Is there something I'm missing?
This was just I needed. Many thanks
Bank Audit:-
I have daily balance file of CC OD loan which is genarate daily basis
Coloumn is Date, account no, Outstanding balance of day
Required:- balance difference between previous day to current date account number wise i.e. 1 apr to 2 nd apr, 2 apr to 3 rd April so on and so forth
I want account wise variance between 2 days
So that I will figure out which account during month having more flatuation in closing balance
Thank you very much
Really helpful!
Thank you!
Brilliant solution and something I've been trying to do and failing. Before anything nice to see you on skillwave, One question regardign the prevous sales, I tried using a measure rather than the var so; I have a prevous date measure ;
MAXXtwo:=MAXX( FILTER(ALL(NonConsec[Date]),NonConsec[Date] <
IF(HASONEVALUE(NonConsec[Date]),VALUES(NonConsec[Date]) ) // Note MAXX iterator
) , NonConsec[Date])
and then tried putting this inside the CALCULAE
CALCULATE([Tsales],FILTER(ALL(NonConsec[Date]), NonConsec[Date] = [MAXXtwo] ))
did not work, conversely in ;
VAR mdate = MAX(NonConsec[Date]) // This does not work but does with a measure,
RETURN
CALCULATE( mdate,FILTER(ALL(NonConsec[Date]),NonConsec[Date] < IF(HASONEVALUE(NonConsec[Date]),VALUES(NonConsec[Date]) ) )) ,
but at least now i have an answer.
If there is categorical and yearly hierarchy in this, how to do that?
Hi Chandeep Just a small request can you make a video on stating the difference between or when do we use ISFILTERED, HASONEVALUE, SELECTEDVALUES and VALUES in DAX.
A small example will be helpful.
Sure! I'll add to my list of videos
Thanks for the suggestion
Excellent video as always ! i had one small problem ,, i used some different data which had a datetable , using the exact same dax it makes the calculation of previous dates sales by inserting a date the day after ?? any quick answers ?
Hi Chandeep,
Thanks for posting this video and well explanation.
Have an one doubt?
If you apply any filter the sales growth and total sales will be same
How can we resolve this issue?
Is it possible to keep sale growth value when we apply filter or slicer in that report?
Thank you so much .,Really helped a lot😀
Glad it was helpful!
Hi, Your back calculation with explanation is really good "SME". Honestly I'm a startup I've been trying to figure out the below can you please support me.
The query is that I need to perform a line chart with the metrics below.
I need to find the difference between months whether has it grown for degrown both in absolutes and percentage wise.
Eg: Jan-10 vs Feb-15 ( 10-15=5) (15-10/15=33%) I want that to calculate part number wise for each month . I have all the years in a single column with the months and values similarly.
epic! but what If I want to reset this each month?
Nice explanation Chandeep. Love your videos and looking forward to see more challenges
Thanks a ton
thanks a lot man, saved my ass from getting fired
Thank you ...can you pls do the same in power pivot in excel.
You are simply brrrrrrrrriliant!
This is an easy example, I need same thing but the date column is not unique, lets say sales for different products so you will have same date repeating more than once
Beautifully explained..!!
Thank you 🙂
Can we have these calculations over calculated column??
Hi, what about when you have dimdate? It does not work when you have dimdate?
Hello Chandeep ,i am new to dax ,bit confused here. In this video we have already declared all(date) in Dax notation then how the selected value function is able to pull single value for each row as per filter date we have provided in table/matrix.It should not work as filters for date column are removed using All function. Please guide me here ,it,s very important to understand this concept.
Thanks for this information video Bro
I want to use this along with to do a groupby based on a column...can we do that? (it should be a measure only)
@Goodly
Awesome! Thanks!
pleasure!
Thanks for valuable video
Hi,
I have been struggling for similar problem.
I referred this but in the second part of it, is not working for me. Can I share problem? Would really appreciate. Please help me!!
Can you please help me with the measure to calculate the sales for last two weeks from Today wherein my week's starting from Saturday?
Hey Chandeep, I want to know more about "Date.IsInPreviousDay" how to use it and what actually it does. Can you put up a video around this it will be just great !!! Thanks
Hi Nishant, can you explain your use case.. I can then try to make an interesting video on that!
Thanks for commenting :)
very nice sir
HEY.. can to tell how to calculate per day percentage. For example, daily attendance percentage, in poweBI
can we calculate Growth From Previous Non Consecutive month?
Previous Date Sales =
VAR CurrentDate = MAX('YourTable'[Date]) // Get the current date from your data
VAR PreviousDate = CurrentDate - 1 // Calculate the previous date
RETURN
CALCULATE(
SUM('YourTable'[Sales]), // Calculate the sum of sales
FILTER(
ALL('YourTable'),
'YourTable'[Date] = PreviousDate
)
)
Hi chandeep, any idea on how to transfer this logic to a card visual? I can’t seem to make it work,it just says “blank” in the card. I need to show on a card the % growth (score from most recent date compared to previous date), which should keep rolling dynamically? Any ideas would be appreciated!!
Fantastic explanation!!!
Glad you liked it!
Hi thanks for this video! just wondering if it's possible to achieve the same with EARLIER? if so, how can we do it? :)
How to calculate growth year over year based on Financial calendar ..
Can we get this test data.... If yes it would be nice to practice
I create one measure named accuracy... I want subtract previous day accuracy value from highest accuracy value till date..so I get deviation for same measure over period of time..can you explain this scenario...
thanks alot 💯
Happy to help!
thank uuuuuuuuuuuuuuuuuuuuuu so much!
glad you like it!
great stuff. thanks.
Terrific video!!
how to make card with the growth value fir selected month, iam getting blank value in the card,
Great work !!!
Thank you bro
Welcome!
Nice work dude
Thanks!
Thank you so much :)
HI....... Can anyone tell me how to show last Six month sales with discontinue month & also I want to show a month which has no sales as a null in last six month filtering?
Really useful. How can you get the sales on previous available date in power query?
Sort the date in ascending order and refer to prev row
th-cam.com/video/UPddzZnsf5w/w-d-xo.html
Thanks Chandeep.
I have a calendar table in model,which contains only quarter and year info(no date fields),I want to calculate growth%,2016-2019 data compare to 2023,2020-2021 compare to 2023,how to achieve it ?
And it is based on some 10 categories,so that can show in a matrix visual
Nice
Hi, Why are you removing using "ALL" in the PreSale, why do we have to remove any filter on the date.? can you please explain
1. The ALL Function removes the filter from the column mentioned i.e. Dates.
2. It gives you all the dates
3. I then compare all the dates against the current date or the date in my filter context.
I hope this helps
Perhaps, you'll understand a lot better once you understand the mechanics of the ALL function.
Video on that coming soon ;)