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,
1. I am trying to calculate Minimum cost , Maximum cost, Average cost per Item.
2. In my Sales Table, I have Total cost and Quantity column
3. I have used Divide Function to Total cost/ Qty = Get Unit price( giving wrong output)
4. When I am applying MIn/ Max to calculated column , I am not getting true value
5. When I am calculating unit price measure I am getting right answer for Unit price. But I am not able to apply MIN/MAX function to measure.
Can anyone please help me
Solved! Go to Solution.
@Anonymous,
You may try MINX Function and MAXX Function which evaluate an expression for each row of a table.
@Anonymous,
You may try MINX Function and MAXX Function which evaluate an expression for each row of a table.
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 |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |