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 Community,
here's my issue:
I created the "Inventory" measure. Down below you can see how one of the visuals (matrix) based on this measure looks ...
Month Inventory
January | 3550 |
February | 2730 |
March | 38551 |
April | 5767 |
May | 4736 |
June | 18336 |
July | 42701 |
August | 277 |
September | 43620 |
October | 17074 |
November | 49214 |
December | 5890 |
Now, I want to create a new measure to give me the smallest number from that visual.
The MIN function, however, only accepts references to columns. So, do I really need to create a table first?
Many thanks in advance!
Solved! Go to Solution.
Hi, sure you can. First you need to generate that table in dax and the use the min. Something like this:
MINX (
SUMMARIZE(
Table; Table[Month]
; "@Inventory"; [InventoryMeasure] )
; [@Inventory]
)
Using SUMMARIZE you can generate a table like the one you show and then use MINX to aggregate the new column [@Inventory].
Regards,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Happy to help!
you can create a formula that uses summarize
https://docs.microsoft.com/en-us/dax/summarize-function-dax
create table a var and then use that table to get min values.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Hi, sure you can. First you need to generate that table in dax and the use the min. Something like this:
MINX (
SUMMARIZE(
Table; Table[Month]
; "@Inventory"; [InventoryMeasure] )
; [@Inventory]
)
Using SUMMARIZE you can generate a table like the one you show and then use MINX to aggregate the new column [@Inventory].
Regards,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Happy to help!
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 |
---|---|
116 | |
105 | |
69 | |
67 | |
43 |
User | Count |
---|---|
148 | |
103 | |
103 | |
88 | |
66 |