Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone, I have one problem and hope that can get your help to solve this one. As you can see below, I want to show the last station name of each workpiece if they finish in that station. Example: the result show be the "Rein" station. But the result somehow is always the station with alphabetically sorting. Even I did it with the DAX or in the visuallization, it was still alphabetically sorting. Could anyone help me with this? Thank you.
Solved! Go to Solution.
Hi @Anonymous
You can start by getting the Max of the Station_end_date for each WorkpieceID and then select the StationName at that time.
Column :
Current Station =
var MAX_DT = CALCULATE(MAX(PA[Station_end_date], ALLEXCEPT(PA,PA[WorkpieceID]))
return CALCULATE(MAXX(FILTER(PA,PA[Station_end_date]=MAX_DT),PA[StationName]), ALLEXCEPT(PA,PA[WorkpieceID]))
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Regards,
Pranit
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
Hi @Anonymous
You can start by getting the Max of the Station_end_date for each WorkpieceID and then select the StationName at that time.
Column :
Current Station =
var MAX_DT = CALCULATE(MAX(PA[Station_end_date], ALLEXCEPT(PA,PA[WorkpieceID]))
return CALCULATE(MAXX(FILTER(PA,PA[Station_end_date]=MAX_DT),PA[StationName]), ALLEXCEPT(PA,PA[WorkpieceID]))
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Regards,
Pranit
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
@Anonymous , Can you share sample data and sample output in table format?
User | Count |
---|---|
106 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |