Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |