Loop function in PowerBI Report Builder Table Expression

Anonymous — Mon, 11 Apr 2022 09:24:23 GMT

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

Re: Loop function in PowerBI Report Builder Table Expression

Anonymous — Thu, 14 Apr 2022 09:44:20 GMT

Hi @Anonymous ,

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

For reference:

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.