Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
please help on below requirements
my sample data
Sl no Role Region
1 G1 Aus
1 G2 Aus
1 G1 Aus
2 G1 Ind
2 G1 Ind
3 G1 US
3 G2 US
3 G3 US
3 G4 US
3 G1 US
4 G1 NZ
4 G1 NZ
Requirements
1. Want to find the Count of Sl No whose role is G1,without moving to other role,
Answer 2 ,(Sl no 2 & 4 , Sl no 1 & 3 starts in G1 and ends in G1 , but go through other roles)
2. want to get an output like this
Sl no hop
1 2
2 1
3 4
4 1
hop defines number of roles assigned to each Sl no (for Sl no 1 , G1 & G2 entries are available , like this
Solved! Go to Solution.
Here are some expressions for your measures:
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Here are some expressions for your measures:
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |