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.
plese see below table, please help me to get this last column calculated.
Scenario
This is a sample of my project master ,
if you trace back the project "Proj_A_0019" it is the third renewal of "Proj_A_0001" , means that project is nenewed 3 times
same way
i need to get calculated the number of times that project has renewed by tracing back as shown in last column of the table.
highly appreciate for your time to help on this,
Solved! Go to Solution.
Hi @Avantha
You could try using a combination of the PATH and PATHLENGTH function
https://docs.microsoft.com/en-us/dax/pathlength-function-dax
Hope this helps
Thanks,
George
Thanks ,
Let me check
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 |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |