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 there,
I currently have a table containing:
ID, Date, Item, Unit Cost
I've created the measures below, so that I can have the lowest costs VS the highest cost plotted on a table visual.
Solved! Go to Solution.
It's hard to answer this without knowing how your data model is structured, if you just have a single table something like the following might work. Note that it could be possible that there are multiple dates for a given Lowest Cost, so I'm using MIN to get the earliest one (you could switch this to use MAX if you want the most recent date)
Low Date=CALCULATE( MIN(Table[Date]) ; FILTER(Table ; Table[UnitCost] = [Lowest Cost] ) ; ALL(Table[Date]) )
You should be able to easily copy this pattern and create a version for the Highest Cost.
It's hard to answer this without knowing how your data model is structured, if you just have a single table something like the following might work. Note that it could be possible that there are multiple dates for a given Lowest Cost, so I'm using MIN to get the earliest one (you could switch this to use MAX if you want the most recent date)
Low Date=CALCULATE( MIN(Table[Date]) ; FILTER(Table ; Table[UnitCost] = [Lowest Cost] ) ; ALL(Table[Date]) )
You should be able to easily copy this pattern and create a version for the Highest Cost.
Hello @d_gosbell !
This is exactly what I needed. The data is comprised of one table only...the one we're working on.
I've already applied this one to the highest cost and to other extractions as well. Just needed to grasp the principle - syntax wise.
Cheers,
Antonio Santos
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 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |