topic Re: balance from previous quarter in DAX Commands and Tips

balance from previous quarter

BeginnerBI — Mon, 30 Jan 2023 18:10:48 GMT

Please I truly need your help. I am trying to get the value from the previous quarter.

I only have one table, and my only date is quarters. I attached a picture to see if I can explain myself.

I will give you kudos all the compliments but please help me on this. Greatly appreciated.

tamerj1 — Mon, 30 Jan 2023 18:58:55 GMT

Please try

Prev. Quarter =
CALCULATE (
SUM ( 'Table'[Column] ),
'Table'[Date] = EOMONTH ( MAX ( 'Table'[Date] ), -3 ),
ALL ( 'Table'[Date] )
)

BeginnerBI — Mon, 30 Jan 2023 19:03:29 GMT

Thank you so much!