Forum Discussion
Helper IIDual Index based on another column
Hi Team
I'm trying to create a second index based on the scheduled date. Ideally, I want only to be able to see the latest scheduled date on the report I'm working on. Below is a snippet and the initial index goes from 1 - 1028 and each record can have multiple inspections.
In this example, I only want to see the row with the scheduled date of 30/07/2022.
Is there a simple(ish) way to do this?
Cheers
Z
Hi ZachUnger
You can create a measure and you don't need to create a new index column.
e.g
Measure = var maxdate=MAXX(FILTER(ALLSELECTED('Table'),[Index]=MAX([Index])),[Scheduled Date]) return IF(MAX([Scheduled Date])=maxdate,1,0)and put the measure to the visual filter:
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi ZachUnger
You can create a measure and you don't need to create a new index column.
e.g
Measure = var maxdate=MAXX(FILTER(ALLSELECTED('Table'),[Index]=MAX([Index])),[Scheduled Date]) return IF(MAX([Scheduled Date])=maxdate,1,0)and put the measure to the visual filter:
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.