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 all,
I am wondering if there is a way to perform a looping in my current situation describe below.
I would like the power BI to insert a text called "Biggest" when it looping through and compare the value in each cell in the "Total Onhold Working Days" based on column "Case ID" (see below)
There is a loop and if statement to be embedded in this custom column (Determinant) and I am not sure how to do it.
May table on the left has been accending and descending order like the picture show.
Hope you can shed a light. thanks.
Regards,
Aiyosap
Solved! Go to Solution.
Hi
The source table is an excel file and there are no other table link to this dataset.
I cannot share example of dataset as it is P&C stuffs. thanks.
Do you know how to resolve this?
Regards,
Yong
Your source table is a regular table in PBI? Are there some other tables involved or related tables? Can you please share a data example, you can use the internal table function. (No screenshot!).
Proud to be a Super User!
Hi
The source table is an excel file and there are no other table link to this dataset.
I cannot share example of dataset as it is P&C stuffs. thanks.
Do you know how to resolve this?
Regards,
Yong
Than please make the effort to create a example table with the existing table function in this forum. 🙂
Yes, i know a way.
Proud to be a Super User!
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 |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |