Forum Discussion

MillarJayakumar

Frequent Visitor

2 years ago

dax

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

Tips and Tricks

MillarJayakumar

Frequent Visitor

2 years ago

Its not working can you recheck it once again my code WINDOW_SUM((IF (LOOKUP(MIN(([Date])),0)>=min(DATEADD('month',-12,[Date]) ) THEN COUNTD([TRID]) ELSE 0 END),-11,0)/12

Memorable Member

2 years ago

Is there an error you are getting

MillarJayakumar
Frequent Visitor
2 years ago
its not showing any value
- saud968
  Memorable Member
  2 years ago
  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!
  - MillarJayakumar
    Frequent Visitor
    2 years ago
    YourTable'[Minimun date 0] ITS NOT A Column its a calculated field LOOKUP(MIN(([Date])),0)

Related content