Forum Discussion
Solved
Split dates into list from date ranges
Hi,
I wonder if somebody could help me to split the data as per example below:
I think I found the solution myself. It only works in Import mode not Direct Query but I have it 🙂 Thank you
2 Replies
maya13 , If you want to split Absense in days You can split in power Query
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
or Text.Split([Absense in day], "/") that will give list ,w which you can expand
I think I found the solution myself. It only works in Import mode not Direct Query but I have it 🙂 Thank you
