Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
For example
January
A 5
B 3
C 8
D 2
February
A 10
B 3
C 2
D 12
For example, in January I would want the entire column to show 8, and Feb entire column should show 12. I want to show the max of the max.
Solved! Go to Solution.
I got this to work,
fffffFund Cal Business Days Passed max per Date =
MAXX(
KEEPFILTERS(VALUES('date'[date])),
CALCULATE(SUM('Date'[Business Days Passed]),filter('date','date'[date]=today()-1)))
the business days passed is the max I'm trying to calculate.
This formula works only for the current month wer're in. Right now for December it returns 9 down the whole column regardless of A, B, C and there's been 9 business days so far this month - yesterday.
The problem is that it is now showing 9 down the column for every previous month too. What I need is for it to not override a previous month's max
Check out the pattern here:
https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149
Generally, you are going to use a SUMMARIZE I believe along with a MAXX potentially.
Thanks for the quick response. @Greg_Deckler
Could you provide more guidance with that article? Every example has the min or max grouped by a category,whereas I would like to show the max regardless of category.
would the solution be something like,
calculate(summarize(fact table, fact table[date],maxx(fact table[max measure]))
max measure meaning what is calculating my number column in my first post.
I got this to work,
fffffFund Cal Business Days Passed max per Date =
MAXX(
KEEPFILTERS(VALUES('date'[date])),
CALCULATE(SUM('Date'[Business Days Passed]),filter('date','date'[date]=today()-1)))
the business days passed is the max I'm trying to calculate.
This formula works only for the current month wer're in. Right now for December it returns 9 down the whole column regardless of A, B, C and there's been 9 business days so far this month - yesterday.
The problem is that it is now showing 9 down the column for every previous month too. What I need is for it to not override a previous month's max
Glad you got it working! Sorry, I was trapped delivering Power BI training all day yesterday!
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |