Forum Discussion
Solved
Cross Join from a single table
Morning everyone and thanks in advance for your support. I need to create a table and call it "presence" starting from a single table called Res_Register. Above mentionned table contains the the co...
From what I undestand you only need to unpivot the data, follow these steps.
- Load your
Res_Registertable into Power Query. - Select the columns
AF1toAEP1(all date columns). - Use the Unpivot Columns feature:
- Right-click the selected columns → Choose Unpivot Columns.
- Rename the new columns:
- Rename the "Attribute" column to
Date. - Rename the "Value" column to
Presence Type.
- Rename the "Attribute" column to
- Format the "Date" column:
- If the column names
AF1,AEP1, etc., are date codes, map or parse them into actual date values
- If the column names
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
- Load your
tharunkumarRTK
Super User
Super UserFrom what I undestand you only need to unpivot the data, follow these steps.
- Load your
Res_Registertable into Power Query. - Select the columns
AF1toAEP1(all date columns). - Use the Unpivot Columns feature:
- Right-click the selected columns → Choose Unpivot Columns.
- Rename the new columns:
- Rename the "Attribute" column to
Date. - Rename the "Value" column to
Presence Type.
- Rename the "Attribute" column to
- Format the "Date" column:
- If the column names
AF1,AEP1, etc., are date codes, map or parse them into actual date values
- If the column names
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
|