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
richbenmintz's avatar
richbenmintz
Icon for Resident Rockstar rankResident 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.