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