Forum Discussion

pmadam's avatar
pmadam
Icon for Helper II rankHelper II
3 years ago

DAX Help

Hi Team,   If someone can can help me with below issue.   I am trying to Calculate Previos Quarter , Previous Month. Issue is for Previous Quater, Prev Month it should give me 2022 Q4 values but ...
DAX
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi pmadam

try to join your table with a qualified date table and utilize Time Intelligence Functions like DATEADD
for previous month,
CALCULATE(
...,
DATEADD(DateTable[Date], -1, MONTH)
)
for previous quarter, DATEADD(DateTable[Date], -3, MONTH)