Forum Discussion
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 ...
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)
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.