function calculate

[Kadrimedquali]

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

[v-chenwuz-msft · Accepted 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.

[Fsciencetech]

Please check below snapshot of the solution and Pbix file enclosed.

https://www.dropbox.com/s/zxm0k2nwef2mjp5/calculate.pbix?dl=0

[Fsciencetech]

Hi,

Can you please share sample pbix here.

Exactly want to understand, what you are doing here.

[Kadrimedquali]

Spoiler

File : https://www.dropbox.com/s/jvl75sjav15ym9u/calculate.pbix?dl=0https://www.dropbox.com/s/jvl75sjav15ym9u/calculate.pbix?dl=0 

many thanks