Forum Discussion

esilva32's avatar
esilva32
Frequent Visitor
7 years ago

combinatorial calculus Dax

Hello guys

I am performing a calculation with DAX on power BI and would like to know if anyone could help me. 

 

I need to calculate the conbination between 10 numbers, 1 to 10 like I have in pbi file. The columns val1 to val5 represents the numbers and the column combination represents the result I'm looking for through the DAX function.

 

The first combination will be 1 2 3 4 5  and last 6 7 8 9 10.

 

Can you help me please? Thanks.

PBIX: http://s000.tinyupload.com/?file_id=21175766585167749434

Best regards,

No RepliesBe the first to reply