Forum Discussion
If you want to get the minimum date from a column named [Date] where the lookup value is 0, you can use the following DAX expression:
LOOKUPVALUE('YourTableName'[Date], 'YourTableName'[YourLookupColumn], 0)
Replace 'YourTableName' with the actual name of your table, and 'YourLookupColumn' with the actual name of the column where you want to find the lookup value of 0.
This DAX expression uses the LOOKUPVALUE function to retrieve the value from the [Date] column where the value in the [YourLookupColumn] is equal to 0.
If you are looking for the minimum date across all rows where the lookup value is 0, you can use the following expression:
CALCULATE(MIN('YourTableName'[Date]), 'YourTableName'[YourLookupColumn] = 0)
Again, replace 'YourTableName' and 'YourLookupColumn' with the actual names of your table and lookup column.
Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!
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
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!