Forum Discussion
i need to convert follwing calculated field WINDOW_SUM((IF [Minimun date 0]>=min(DATEADD('month',-12,[Date]) ) THEN [TR Count] ELSE 0 END),-11,0)/12 as PBI dax code
Is there an error you are getting
its not showing any value
Try this
PBI DAX Code =
CALCULATE(
AVERAGEX(
FILTER(
ALL('YourTable'),
'YourTable'[Minimun date 0] >= MINX(ALL('YourTable'), DATEADD('YourTable'[Date], -12, MONTH))
),
'YourTable'[TR Count]
),
DATEADD('YourTable'[Date], -11, MONTH),
'YourTable'[Date]
) / 12
If this does not work can you share the sample file, and remove sensitive data?
Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!YourTable'[Minimun date 0] ITS NOT A Column its a calculated field LOOKUP(MIN(([Date])),0)