Forum Discussion
Solved
Help with DAX Columm
Dear All Please I need help with a function in DAX as a column and not as a measure that shows the sum of the last 3 months. I have this example and the yellow column should be the result of a co...
Ultimos 3 Meses = VAR _MaxDate = CALCULATE( MAX( 'Table'[Date] ), ALLEXCEPT( 'Table', 'Table'[Product]) ) VAR _Result = CALCULATE( SUM( 'Table'[Value] ), DATESINPERIOD( 'Table'[Date], _MaxDate,-3,MONTH ) ,ALLEXCEPT( 'Table','Table'[Product] ) ) RETURN _ResultRegards
sanalytics
yes. i did also the same thing.. After i posted, i see Joe's solution