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.
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!
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 |
---|---|
113 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |