Forum Discussion
Split a single row into multiple rows
Hello Power BI community, I am new to power BI and DAX therefore my skills are kinda of limited. I have to split a single row into multiple rows. let me illustrate my request : Employee ID...
Anonymous Please try with below steps:
1. Create a new MonthName table from your existing DimDate table (if you don't have one, create a Date table)
_DimMonth = VALUES(_Date[Date].[Month])
2. Then, create a new table as below which will be your expected output
Test273Out = CROSSJOIN(SELECTCOLUMNS(Test273SplitRows,"EmployeeID",Test273SplitRows[EmployeeID],"Salary",Test273SplitRows[Salary]/12,"Bonus",Test273SplitRows[Bonus]/12),_DimMonth)
Anonymous Please try with below steps:
1. Create a new MonthName table from your existing DimDate table (if you don't have one, create a Date table)
_DimMonth = VALUES(_Date[Date].[Month])
2. Then, create a new table as below which will be your expected output
Test273Out = CROSSJOIN(SELECTCOLUMNS(Test273SplitRows,"EmployeeID",Test273SplitRows[EmployeeID],"Salary",Test273SplitRows[Salary]/12,"Bonus",Test273SplitRows[Bonus]/12),_DimMonth)