Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I'm going to try to explain my situation because is a little bit complicate xD.
I have a "master" excel file with some data like this:
In this excel we have some columns like location code, name of location and the rest of the columns are sales amount and % of
discount depending of the quantity of the sales amount.
Then I have a dashboard with a table like this:
In this table yellow is name of client , red is sales amout and blue is the %discont depending the total sales amount.
The question is i want to change for one percentaje in excel file and that automactly applys to this table. The measure that I'm using to extract the % is:
Banda = VAR _banda1 = MAX(Farmacias[banda1]) VAR _banda2 = MAX(Farmacias[banda2]) VAR _banda3 = MAX(Farmacias[banda3]) VAR _banda4 = MAX(Farmacias[banda4]) VAR _banda5 = MAX(Farmacias[banda5]) VAR _banda1a = MAX(Farmacias[%banda1]) VAR _banda2a = MAX(Farmacias[%banda2]) VAR _banda3a = MAX(Farmacias[%banda3]) VAR _banda4a = MAX(Farmacias[%banda4]) VAR _banda5a = MAX(Farmacias[%banda5]) VAR _banda6a = MAX(Farmacias[%banda6]) RETURN SWITCH(TRUE(); ([sumcantidad]> 0 && [sumcantidad]<=_banda1); _banda1a; ([sumcantidad]>_banda1 && [sumcantidad]<=_banda2); _banda2a; ([sumcantidad]>_banda2 && [sumcantidad]<=_banda3); _banda3a; ([sumcantidad]>_banda3 && [sumcantidad]<=_banda4); _banda4a; ([sumcantidad]>_banda4 && [sumcantidad]<=_banda5); _banda5a; ([sumcantidad]>_banda5); _banda6a; 0 )
The problem here is the MAX of the variable, because for example if I change a number in one row but depending the of the number is taking the MAX. I don't know if is possible to access directy to a row , not to column.
Sorry for the explanation, really complicate to me explain this topic 😞
Dear cromero,
I think, your question is incompleted one. Can you please brief ellaborately?
Regards,
Pradeep
Yes , sorry was a mistake now you have more information 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |