Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi There,
I have a process that need to be followed step by step, just to be sure that everyone is doing their stuff in time, so I have a table with the steps and the days to have the thing done. So I want to be able to show the actual step, and the one that is coming.
Here the example:
Actual Event | Days To Make It | Responsible |
Writte the Letter | 3 | Ann |
Code the Letter | 1 | Peter |
Send the Letter | 2 | Mike |
So I need a way to create a Column that will be displaying the next step, in relation with the actual phase,
Here the example:
Actual Event | Days To Make It | Responsible | Next Step |
Writte the Letter | 3 | Ann | Code the Letter |
Code the Letter | 1 | Peter | Send the Letter |
Send the Letter | 2 | Mike | - |
I have like 24 events, so a nested IF sounds like a dummy solution,
Any ideas?
Thanks
Solved! Go to Solution.
Hi @rokacl ,
You can create an index column wrt to the steps.
Then use the measure
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
hi @rokacl
First, you need define a sort number for event in a dim event and create a relationship with data table
Then in data table, create a new column as below:
Next Step = CALCULATE(MAX('Dim Event'[Actual Event]),FILTER(ALL('Dim Event'),CALCULATE(MAX('Dim Event'[Sort No]))=RELATED('Dim Event'[Sort No])+1))
Result:
and here is sample pbix file, please try it.
Regards,
Lin
Hi @rokacl ,
You can create an index column wrt to the steps.
Then use the measure
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Thank you very much, I used the switch just to go on, but this was the kind of solution I was thinking of, I´m gonna try it today,
Have a nice day!
@rokacl , Do you have some mater for Event order? Looking at this we can only hard code event order. What we need is an event order table. We can put that into this table using related or lookupvalue.
And if they are non-continuous we can use rank to make them continuous
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |