Forum Discussion
kavitabehera
3 years agoAdvocate II
Calculated minimum value by multiple categories
I wanted to create a calculated table that fetches the minimum value by 2 text columns. For example: Let's take this below example, the question is to bring the minimum sale for the region by cat...
- 3 years ago
Hi kavitabehera ,
I think it is just necessary to add another calculation table on top of the example file
(1) Add a calculation tableTable 2 = SUMMARIZE ( 'Table', 'Table'[Region], "MIN",MIN('Table'[MinXSale]) )(2)Final output
Best Regards,
Gallen Luo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-jialluo-msft
3 years agoCommunity Support
Hi kavitabehera ,
I tried to open the file link, but it says permission is required.
Please upload the sample file directly to the attachment or remove the access restriction from the download link
Best Regards,
Gallen Luo
kavitabehera
3 years agoAdvocate II
You can access the file now.
Here is the link.
https://drive.google.com/file/d/1xGwidMFLevCFmp9OQHjSvlj-skPZEATn/view?usp=sharing