Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi community,
I'm trying to use the divide function but it's not showing the correct results for me. The formula looks like this:
Omloopsnelheid = DIVIDE(SUM(GRV_StockpositionsPerDay[Stock]);SUM('100_Voorraadmutaties'[Eruit positief]);0)
The GRV_StockPositionsPerDay[Stock] is the 'Voorraadstand' in the first picture. The 100_Voorraadmutaties[Eruit positief] is the Eruit posititief in the second picture. So what I want is 65.401,00 / 700.348,00 = 0,09338... But it's giving me 0,00290.
Anyone who knows how to tackle this problem? Thanks in advance!
Kind regards,
Dexter
Solved! Go to Solution.
it seems that the two table is not properly related.
Look to whats append if you bring the "Eruit positief" column in the first table.
If you don't solve post the pbix, i'll try to take a look.
GP
it seems that the two table is not properly related.
Look to whats append if you bring the "Eruit positief" column in the first table.
If you don't solve post the pbix, i'll try to take a look.
GP
Thank you GP, when you said relation I checked into the relation between the tables and thats fixed it! 🙂
If I just divide the columns without using DAX it gives the same answer. Also when I use divide the numerator and denumerator need a function I believe.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
82 | |
71 | |
49 |
User | Count |
---|---|
143 | |
121 | |
112 | |
58 | |
57 |