Forum Discussion

CSpina's avatar
CSpina
Helper III
6 years ago

Loop fopr DAX

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?

 

Need Help

5 Replies

    • parry2k's avatar
      parry2k
      Super User
      6 years ago

      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.⚡

    • CSpina's avatar
      CSpina
      Helper III
      6 years ago

      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.

  • richbenmintz's avatar
    richbenmintz
    Resident Rockstar
    6 years ago

    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.