Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I created calculatedtable "B" with groupby function from another table "A".
Table "A" has a date field.
I'd like to add the most recent dates from table "A" for each group in table "B".
Any ideas on how this coule be done?
Solved! Go to Solution.
yes, sorry
Column = CALCULATE(MAX(TableA[Date]), FILTER(ALL(TableA), TableA[group]=EARLIER(TableB[group])) )
Just to make sure I'm understanding, in this scenario:
TableA = Original table
TableB = CalculatedTable
"group" = field TableB is groupedby
Is that right?
the date field doesn't exist in tableB, so if I change that to:
Column = CALCULATE(MAX(TableA[Date]), FILTER(ALL(TableB), TableB[group]=EARLIER(TableA[group])) )
I get the following error:
"A single value for column 'group' in table 'TableA' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."
Thanks in advance for any other insights!
Perfect. Thanks again!
User | Count |
---|---|
104 | |
86 | |
80 | |
71 | |
71 |
User | Count |
---|---|
112 | |
100 | |
98 | |
72 | |
66 |