Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
57 | |
21 | |
18 | |
16 | |
12 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |