Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
The date column is split in two rows. Any suggiestions how can I combnine the date number from the first row with the month name from the second row?
Solved! Go to Solution.
Hi,
1. split column after first character from right to identify where you have "-" and where not
2. add an if column, where is "-", column that you have now , where not null
3. on that column filled down to fill null values
4. add column - column you have now&column resulted at step 3
5. delete rows unuseful on initial column like Jan, Feb etc
Best,
Cosmin
Hi,
1. split column after first character from right to identify where you have "-" and where not
2. add an if column, where is "-", column that you have now , where not null
3. on that column filled down to fill null values
4. add column - column you have now&column resulted at step 3
5. delete rows unuseful on initial column like Jan, Feb etc
Best,
Cosmin
Worked like a charm thank you!!
@Petrosfl You could probably create two separate data sources from that - one with "Count" not null and one with "Count" null, index those columns in each data source and then merge.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |