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 want to create a new table from my table with customerId and startdates which returns one row per customer with the minimum dat per customer. I've tried to use SELECTCOLMUNS and FILTER and I get a table with single customerId's but the minimum date is not calculated per customer but from the total. How can I get the minimum date per customer?
Solved! Go to Solution.
Hey Ingrid,
You can try the following:
MinFvoorzieningTbvEerste=
SUMMARIZE (
'FvoorzieningTbvEerste',
'FvoorzieningTbvEerste'[NrClient],
"ingang", MIN ( 'FvoorzieningTbvEerste'[Ingang] )
)
Kind regards
Hey Ingrid,
You can try the following:
MinFvoorzieningTbvEerste=
SUMMARIZE (
'FvoorzieningTbvEerste',
'FvoorzieningTbvEerste'[NrClient],
"ingang", MIN ( 'FvoorzieningTbvEerste'[Ingang] )
)
Kind regards
Hi @ingrid
You could do something like:
New Table =
ADDCOLUMNS (
DISTINCT ( Table1[NrClient] ),
"DatumIngang", CALCULATE ( MIN ( Table1[Ingang] ) )
)
You might have to filter the first argument of the ADDCOLUMNS. If you explain what the filter exactly does in your code (I don't see it completely), we can get to a more accurate answer
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
I would make this table in the query editor with a Group By step. Or you should use ADDCOLUMNS(SUMMARIZE(... instead of SELECTCOLUMNS which doesn't do any aggregation.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |