Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there,
I am trying to display information into a table visual. I want to show the individual Id and their names on the table visual whose license date is expired. An Individual can renew license multiple times in the past so my logic for checking expiry license date is to pick the most recent one. Here is my measure:
Solved! Go to Solution.
@Dunner2020 can you try this
Expired License =
CALCULATE (
DISTINCTCOUNTNOBLANK ( Table[IndividualID] ),
FILTER (
VALUES ( Table[IndividualID] ),
Table[IndividualID] = MAX ( Table[IndividualID] )
&& MAX ( Table[TableExpiryDate] ) < TODAY ()
)
)
@Dunner2020 can you try this
Expired License =
CALCULATE (
DISTINCTCOUNTNOBLANK ( Table[IndividualID] ),
FILTER (
VALUES ( Table[IndividualID] ),
Table[IndividualID] = MAX ( Table[IndividualID] )
&& MAX ( Table[TableExpiryDate] ) < TODAY ()
)
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
77 | |
68 | |
54 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |