topic Re: Help with DAX Columm in DAX Commands and Tips

Help with DAX Columm

rod_puente — Fri, 20 Sep 2024 07:17:08 GMT

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 column function by DAX:

Regards

Rodrigo P.

Re: Help with DAX Columm

jkrumb — Fri, 20 Sep 2024 07:52:37 GMT

Hello, I hope I understood your request correctly

Sum3LastMonths =
VAR CurrentDate = 'YourTable'[Fecha]
RETURN
CALCULATE(
SUM('YourTable'[Valor]),
DATESINPERIOD('YourTable'[Fecha], CurrentDate, -3, MONTH)
)

Re: Help with DAX Columm

Joe_Barry — Fri, 20 Sep 2024 08:08:38 GMT

Hi rod_puente

You can try this

Last 3 Months Sales = VAR _MaxDate = CALCULATE(MAX('Table'[Fecha]), ALLEXCEPT('Table', 'Table'[Producto])) RETURN CALCULATE ( SUM('Table'[Valor]), DATESINPERIOD('Table'[Fecha], _MaxDate, -3, MONTH), ALLEXCEPT('Table', 'Table'[Producto]) )

Hope this helps

Joe

Re: Help with DAX Columm

sanalytics — Fri, 20 Sep 2024 08:30:19 GMT

rod_puente

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 _Result

Regards

sanalytics

Re: Help with DAX Columm

PhilipTreacy — Fri, 20 Sep 2024 08:43:32 GMT

sanalytics

Isn't that exactly the same answer that Joe_Barry gave?

Phil

Re: Help with DAX Columm

sanalytics — Fri, 20 Sep 2024 08:57:01 GMT

PhilipTreacy

yes. i did also the same thing.. After i posted, i see Joe's solution