Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
  • Mariusz's avatar
    Mariusz
    7 years ago

    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.
    Mariusz Repczynski

     

Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
7 years ago

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.
Mariusz Repczynski

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

This worked like a charm, thanks so much! I definitely wouldn't have got there without you.