Loop function in PowerBI Report Builder Table Expression

[Anonymous]

Hi, I am wondering if there is an option to create a loop in the Report builder table field Expression based on textBox value:

I want to compare column by column to find first with a value less than 0. If there is a column with a value less than 0 then do the calculation.

The variable would be the number of the TextBox incremented by 2:

ReportItems("Textbox"variable"").value < 0 

The result would be date 

FORMATDATETIME(DATEADD("d","Variable2",today()),DateFormat.ShortDate)

where variable2 is starting from 0 and each time it passes through loop it adds 1

[Anonymous]

Hi @Anonymous ,

I think you can try IIF() function to calculate in loop.

For reference:

Report Builder- Nested If Statements with Multiple Values to Categorize

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.