Forum Discussion

CSpina's avatar
CSpina
Icon for Helper III rankHelper 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
  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper 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
    Icon for Helper III rankHelper 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.

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      6 years ago

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