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)

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

But this works only when there is some  Year or Quarter selection in slicers. But i want without any selections of slicers from date. 

 

I get "dateadd expects a contiguous selection" error msg if i do not make any date selections or add Year ot Quarter to the table. And i have one - many directional tables.