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.
Hello,
This may sound really basic, but I've run out of neurons by now and I need your help.
I need to get the max value in a column, but the table is filtered by a Calendar Table.
Table1
Date Item Value
01/01/2019 Item1 2
02/01/2019 Item2 3
05/10/2019 Item3 4
I've been using this DAX measure to get the max value:
LowestCost = calculate(min(Table1[Value]);Allexpect(Table1;Table1[Item]))
I now need to get this max value, but considering the date range in the Calendar Table I have filtering Table1.
Thanks in advance!
Antonio Santos
Solved! Go to Solution.
Hi @Asantos2020 ,
try this.
HighestCost =
CALCULATE (
MAX ( Table1[Value] ),
FILTER ( ALL ( 'Calendar' ), 'Calendar'[Date] <= MAX ( 'Calendar'[Date] ) )
)
Regards,
Marcus
Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Hi @Asantos2020 ,
try this.
HighestCost =
CALCULATE (
MAX ( Table1[Value] ),
FILTER ( ALL ( 'Calendar' ), 'Calendar'[Date] <= MAX ( 'Calendar'[Date] ) )
)
Regards,
Marcus
Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
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 |
---|---|
107 | |
94 | |
77 | |
63 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |