Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I am trying to find MAX date for a particular License number but i am not able to acheive this.
Please find these for refrence
_MsrMaxExpirationDate =
MAXX(
SUMMARIZE(
DimStaffLicenses,
DimStaffLicenses[LicenseNumber],
"MaxExpirationDate", MAX(DimStaffLicenses[ExpirationDate])
),
[MaxExpirationDate]
)
But not getting MAX date with this condtion
Solved! Go to Solution.
@Rkrama746
Create this measure and use it:
_MsrMaxExpirationDate =
CALCULATE (
MAX ( DimStaffLicenses[ExpirationDate] ),
ALLEXCEPT ( DimStaffLicenses, DimStaffLicenses[LicenseNumber] )
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Rkrama746
Create this measure and use it:
_MsrMaxExpirationDate =
CALCULATE (
MAX ( DimStaffLicenses[ExpirationDate] ),
ALLEXCEPT ( DimStaffLicenses, DimStaffLicenses[LicenseNumber] )
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thanks A lot
User | Count |
---|---|
70 | |
43 | |
21 | |
21 | |
14 |
User | Count |
---|---|
124 | |
42 | |
39 | |
28 | |
25 |