Forum Discussion
kavitabehera
Advocate II
3 years agoCalculated 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
Community Support
3 years agoHi 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
Advocate II
3 years agoYou can access the file now.
Here is the link.
https://drive.google.com/file/d/1xGwidMFLevCFmp9OQHjSvlj-skPZEATn/view?usp=sharing