accumulative dax problem

MSAYED26 — Mon, 29 Apr 2024 08:19:14 GMT

I want to calculate accumlative ,I have to different date (columns date of return2024,rows date of production) in table below accumlative in march 2004 should be 3 , also i want to calculate accumlative with last 5 years

I use

ACCumlative last 5 years =

CALCULATE(

[Total Order],

FILTER(

ALLSELECTED('Date'[Date]),

ISONORAFTER('Date'[Date], MAX('Date'[Date]), ASC)

),DATESINPERIOD('Date'[Date].[Date],MAX('Date'[Date]),-5,YEAR)

)

but not working

Re: accumulative dax problem

lbendlin — Mon, 29 Apr 2024 22:36:31 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

topic accumulative dax problem in DAX Commands and Tips

accumulative dax problem

Re: accumulative dax problem