Forum Discussion
Creating a new row with IF query in DAX
Hello, I'm working with HR data and need to create a row to represent staff activity undertaken each by month. For example: Month Name Sick Leave in Month Annual Leave in Month Apri...
Hi Anonymous
1. In Query Editor go to Transform > New Query > New Source > Blank Query,
2. Go to advanced editor and paste the code and rename the Query1 to ExpandMonths.
3. When in your staff data table go to Add Column > General > Invoke Custom Function.
4. Make sure you set everything as on the screenshot below.5. this will add new column "ExpandMonths", all you need to do now is click the two arrows an select expand to new rows.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
HotChilli
Community Champion
Community ChampionYes, that did go through my mind but the sample data doesn't seem to fit that requirement e.g. Janet Bloggs has leave in June and July 19 but has left in April 2018
Sorry, that was a mistake. It's not easy to give a complete dataset to work with as I would need to anonymise everything.