Forum Discussion
WinterMist
Impactful Individual
Impactful IndividualBest Practices Q - Handling Text ID Fields With Comma Delimited Values
Hello Community, I'm looking for Best Practice (or otherwise) guidance on how to handle Power BI reporting for this specific undesirable source data situation. PROBLEM: Usually in source data...
Hi WinterMist
To split the [Rejection Reason ID] column, in Power Query, do the following:
1. Select 'Fact Rejections'[Rejection Reason ID] and hit "Split Column".
2. Use "comma" as the delimiter.
3. Open "Advanced Options" and set "Split into" to "Rows"
4. Close & ApplyI hope this helps.
WinterMistImpactful Individual
Impactful Individual
Works beautifully! Thank you!
So is it just personal preference then at which layer the transformation occurs?
- DB Layer
- DW Layer
- Power Query Layer
Regards,
Nathan
- gmsamborn
Super User
Ideally, you want to do it as far upstream as possible. (but that can be very limiting/impossible in certain scenarios)
I'm not very good at PQ's M language but if I can find a way to do it in PQ instead of DAX, I'd go with PQ.