How to perform looping logic in calculate column

[aiyosap]

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

[andhiii079845]

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!). 

[aiyosap · Accepted 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

[andhiii079845]

Than please make the effort to create a example table with the existing table function in this forum. 🙂
Yes, i know a way.