topic Re: ACCUMULATED MIN in DAX Commands and Tips

ACCUMULATED MIN

jhodasoft — Tue, 04 Apr 2023 20:46:00 GMT

Good afternoon!, The idea is to get the accumulated from the Projection column and I can't get it. Can someone help me?
Image 01

Image 02

Image 03

Re: ACCUMULATED MIN

FreemanZ — Tue, 04 Apr 2023 22:15:34 GMT

hi jhodasoft

try like:

Measure =

SUMX(

FILTER(

ALL(TableName),

MONTH(TableName[Date])<=MAX(MONTH(TableName[Date]))

[Projection]

)

Re: ACCUMULATED MIN

jhodasoft — Mon, 10 Apr 2023 20:49:55 GMT

Thanks for answering FreemanZ , but I still can't get it.

Re: ACCUMULATED MIN

tamerj1 — Mon, 10 Apr 2023 21:18:11 GMT

jhodasoft

You cannot calculate a variable inside CALCULATE. You need not to use a variable in this case. The MIN aggregation has to be referenced directly inside the CALCULATE function.

Re: ACCUMULATED MIN

FreemanZ — Wed, 12 Apr 2023 03:55:46 GMT

hi jhodasoft

post some sample data and let us see.

Re: ACCUMULATED MIN

jhodasoft — Wed, 12 Apr 2023 22:28:18 GMT

Hi FreemanZ , thanks for answering, I will copy part of the data below.