'applicate for loop in power BI

I am trying to create a new table in Power BI desktop and i have some repeated values, but I cannot automate the process like using a For Loop. please i need help to make this code dynamique to generate the new table.

New tableFraisEcon=
   UNION(
     ROW("parametre","AUTO","type","MsFixe","Real",CALCULATE(SUM(table_Ms[FixeR]),table_Ms[Param]="AUTO"),"Budget", CALCULATE(SUM(table_Ms[FixeB]),table_Ms[Param]="AUTO")),

ROW("parametre","AUTO","type","MsVar","Real",CALCULATE(SUM(table_Ms[VarR]),table_Ms[Param]="AUTO"),"Budget", CALCULATE(SUM(table_Ms[VarB]),table_Ms[Param]="AUTO")),
.........

I want to dynamically generate Param (a formula like using For Loop) to calculate the sum knowing that i have 70 param

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'applicate for loop in power BI

Sources

Related Questions