Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
hello
I want to calculate for each number an amount it is equal one of these amount.
Example : for 120001CDQ = 43200, not the sum of this number 1063800
thanks
File : https://www.dropbox.com/s/jvl75sjav15ym9u/calculate.pbix?dl=0
Solved! Go to Solution.
Hi @Kadrimedquali ,
Put [Numéro] and [Montant] in a table visual. Then set [Numéro] Don't summarize and [Montant] Don't summarize or maximun via down arrow as the following show:
The result:
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Kadrimedquali ,
Put [Numéro] and [Montant] in a table visual. Then set [Numéro] Don't summarize and [Montant] Don't summarize or maximun via down arrow as the following show:
The result:
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Please check below snapshot of the solution and Pbix file enclosed.
https://www.dropbox.com/s/zxm0k2nwef2mjp5/calculate.pbix?dl=0
Hi,
Can you please share sample pbix here.
Exactly want to understand, what you are doing here.
User | Count |
---|---|
107 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |