Calculate Growth From Previous Non Consecutive Date

Fellas thanks so much for pouring in your answers. Here is the solution for anyone who needs more explanation.

---Download Files Here

- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

- - - - Blog - - - -

[chinmayjain]

If there is categorical and yearly hierarchy in this, how to do that?

[srikrishnasoftskills]

My Source : PostgreSQL
Connection: Direct Mode
We have calculated
Days of forecast=
IF(
(OR(Source_Acticity[Count of movement Days]<'Date'[Total movment Days], Source_Activitu[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.

[arunkumarkesavan]

You are awesome in all aspects like communications, length of the video, presentations and DAX... Kudos bro!!!

[bimalpatel]

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
)
)

[jaybuddhadev]

helpful. got stuck in one calculation and this video helped to get the right way.. thanks

[mustseeiran]

Hi, what about when you have dimdate? It does not work when you have dimdate?

[farooqueasad]

Thank you ...can you pls do the same in power pivot in excel.

[hiteshdangodra]

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.

[huleshsahu]

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!!

[williamarthur]

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.

[haintuvn]

can we calculate Growth From Previous Non Consecutive month?

[AnjaliSingh-jpyg]

HEY.. can to tell how to calculate per day percentage. For example, daily attendance percentage, in poweBI

[bittujha]

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?

[kuldeepraghav]

How to calculate growth year over year based on Financial calendar ..

[BholaPaswan-frqx]

Can we have these calculations over calculated column??

[pillajanardhankumar]

how to make card with the growth value fir selected month, iam getting blank value in the card,

[erenatis]

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?

[NouYunho]

thanks a lot man, saved my ass from getting fired

[mohiniingale]

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?

[kariannekies]

Thank you so much! I have been struggling with this for a week and you solved in 8:51 min. Subscribed!