Forum Discussion
Spliting (inconsistent data) column into multiple columns - Power BI
Greg_Deckler Thanks for the quick response. What I was wondering if there is a way to code with conditions at row level.
1. Campaign name: Search each row for word 'Campaign' and populate till the left most delimiter with custom '-', else populate what ever the row has. As no other information like year/quarter, product no other information is available if campaign word is not present.
2. Country: It is always followed by campaign name, else null
3. Year/quarter: typical format '17Q1', 'Q2', 'Q3-Q4', '16Q2-Q3' - Can we use reference of other column 'date' here directly?
4. Market type: only three types 'ATL', 'BTL' or 'TTL' else null
5. Product type: only two types SB or GOC else null
6. Promotion type: 1st condition all the infomation followed by SB or GOC, If else market type (ATL, BTL, TTL) else null
I hope this will give a better understanding of the data for all the users.
srikanthjukuri You can using calculated columns in Power Query editor or DAX but your process won't work because your first line is missing the delimiter between campaign and country so it would mess up.