Forum Discussion
How to create a shift rotation schedule in Power Bi?
I've been trying to figure out how to manage this code related to my data. Is there a possibility you could simplify this example a litte more? For an example, the long green text - is that a source? And where do i put this code - Power Bi or the Query?
// Noob 😄
Super UserCreate a new blank query (or duplicate any existing query) and open the advanced editor and replace all the text with the M code I provided. This will recreate exactly what I did and you can walk through the applied steps.
Instead of connecting to a source, I use the Enter Data tool. The long green text is that entered data in a compressed format.
To apply to your data, you're essentially trying to recreate the last three steps (Filtered Rows, Repeated Table, and Added Index).