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 Pbi Friends,
Having problem with 1 messure... it shows data correct, but total not so good.
Its a Purchase Order(only 2017 data) with Calendar (Only 2017 data) and Product Master
Basically i need to know :
( Average Price last quarter * Quantity Current Quarter ) - ( Average Price Current quarter * Quantity Current Quarter )
Its doing the calculations corretly, but when try to get total, its goes from "$4.00" to "$198.00"
Atual = Current Quarter Av. Price
Ultimo = LastQuarter Av. Price
Qtde = Quantity
https://i.imgur.com/I8URAdT.png
Solved! Go to Solution.
You may try a similar way as shown here.
You may try a similar way as shown here.
Hi Pbi Friends,
Having problem with 1 messure... it shows data correct, but total not so good.
Its a Purchase Order(only 2017 data) with Calendar (Only 2017 data) and Product Master
Basically i need to know :
( Average Price last quarter * Quantity Current Quarter ) - ( Average Price Current quarter * Quantity Current Quarter )
Its doing the calculations corretly, but when try to get total, its goes from "$4.00" to "$198.00"
Atual = Current Quarter Av. Price
Ultimo = LastQuarter Av. Price
Qtde = Quantity
https://i.imgur.com/I8URAdT.png
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 | |
100 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |