Forum Discussion
Solved
Getting previous 3MMA
Hi, can someone help me to figure out how to get this? currently i have 3MMA but how to get Jan 2022 and Nov, Dec 2021 measure for 3mma 3MMA SOM = CALCULATE(AVERAGEX(values(mv_fact_s...
Hi Easley06 ,
Please enable the Time Intelligence. This will let the data column has Date Hierarchy.
Create a measure via the expression below.
Measure = CALCULATE ( AVERAGE ( 'Table'[Values] ), FILTER ( 'Table', [Date] >= DATE(YEAR(TODAY()),MONTH(TODAY())-5,1) ) )This measure will filter the context and if the context have no rows match the condition, it will return blank.
Result:
Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
