Forum Discussion
Peejz_Jalmasco
Helper I
Helper IDAX Conditional Lookup
Hi! I've got a table that look like this: ID SL CODE Status 1 SL0001 Current 1 SL0002 Current 2 SL0003 Past Due 2 SL0004 Current 3 SL0005 Past Due 3 SL0006 Past D...
Stats = CALCULATE(MAX('YourStatus'[Status]),ALLEXCEPT('YourStatus','YourStatus'[ID]))my table is "YourStatus'
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
NathanielThanks for your help. I've solved this using the MAXX function to convert the measure "[Account Status2]"
Final Status = CALCULATE(MAXX(VALUES('PN MASTER DATA'[SLCODE]),[Account Status2]), ALLEXCEPT('PN MASTER DATA','PN MASTER DATA'[NAME]))
Nathaniel_C
Community Champion
Community ChampionHi Peejz_Jalmasco , what does the measure look like?
Peejz_JalmascoHelper I
Helper IThanks for your help. I've solved this using the MAXX function to convert the measure "[Account Status2]"
Final Status = CALCULATE(MAXX(VALUES('PN MASTER DATA'[SLCODE]),[Account Status2]), ALLEXCEPT('PN MASTER DATA','PN MASTER DATA'[NAME]))