iteration

2 Topics

Dax Help - IF('Table A'[column X] = "yes", Sum (Table Y[Column Y]), Sum (Table Z[Column Z])
If ( 'Table A'[column X] = "yes", Sum (Table Y[Column Y]), Sum (Table Z[Column Z]) Table A - approximately 500 rows. Table X - 10s of thousands of rows Table Z - 10s of thousands of rows Hello, Table A has a list of "stores" and column x has a status of "yes" or "no". I want to iterate for every row in Table A to sum the matching "store" values in either Table Y or Table Z. For additional Clarity, IF Table A Store 123 = Yes, Sum Table Y [column Y], otherwise Sum [Table Z[Column Z] I pretty sure I have the sum calulations { Sumx(Filter(Store,Store[Status]="Yes"),CALCULATE(sum(NEW_Services[Revenue])) and Sumx(Filter(Store,Store[Status]="No"),CALCULATE(sum(OLD_Services[Revenue])) } but can't figure out how to apply the iterated IF Thanks in advance.
Solved
JMD22Si
3 years ago Place DAX Commands and Tips
1.1KViews
0likes
5Comments
Recursive calculation with cumulated sums
Hello all, I am struggling in Power Bi to compute the following formula (remain to engage) RTE(m) = MAX [ sum[TSP] (m0 to m) - sum[AEFP] (m0 to m) -sum[RTE] (m0 to m-1) ; 0] see example below would you have any idea to solve this please ? thank you for your support regards gen Month Total Spend planned (TSP) Already engaged for payment (AEFP) Remain to engage (RTE) 1 200 180 20 2 100 80 20 3 150 30 120 4 100 10 90 5 200 5 195 6 50 50 total 800 305 495
Anonymous
5 years ago Place DAX Commands and Tips
892Views
0likes
2Comments