Loop fopr DAX

[CSpina]

Hi boys and girls,

I need to repeat a CALCULATE, but changing only 'fEMPL AUT Ciclos'[P1] for 'fEMPL AUT Ciclos'[P2]. There are 150 different "P".

Any ideas?

[richbenmintz]

@CSpina ,

You are not really trying to perform recursion, you are trying to build a measure which adds an unknown number of columns together, kind of like stitching dynamic SQL together, as @parry2k mentioned unpivotting your data into rows is the way to go. You would perform this in Power Query using the Unpivot feature.

[Anonymous]

https://community.powerbi.com/t5/Community-Blog/For-and-While-Loops-in-DAX/ba-p/636314

here is a link to a solution 

[CSpina]

Thanks D,

Almost worked. The problem now is I have a SUM('fEMPL Ciclos'[P1])  where P1  can be P1, P2, P3... Pn.

I don´t know how to get 'fEMPL Ciclos'[P1] ou how to create P1 based on [Value] from series.

'fEMPL Ciclos'[P & [Value]] - Didn´t work.

[parry2k]

@CSpina it is not the right approach, better to unpivot.

[parry2k]

@CSpina you should be unpivot your table for better design and then you don't need to do this dance with DAX.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡