Forum Discussion
Transform data from a summarized format into a more granular format
I would like to know if Power BI has such function that for example. I have a regular allowance payment to employee and the data report is only show one row with the payment period and i would to lik...
You could create a new table like
Detailed Table = SELECTCOLUMNS( GENERATE( 'Table', VAR _Dates = FILTER( CALENDAR( 'Table'[Start Date], 'Table'[End Date] ), DAY( [Date] ) = 1 ) VAR Result = SELECTCOLUMNS( _Dates, "Start Month", [Date], "End Month", EOMONTH( [Date] , 0 ) ) RETURN Result ), [Name], [Allowance], [Start Month], [End Month] )
johnt75
Super User
Super UserYou could create a new table like
Detailed Table = SELECTCOLUMNS(
GENERATE(
'Table',
VAR _Dates = FILTER( CALENDAR( 'Table'[Start Date], 'Table'[End Date] ), DAY( [Date] ) = 1 )
VAR Result = SELECTCOLUMNS(
_Dates,
"Start Month", [Date],
"End Month", EOMONTH( [Date] , 0 )
)
RETURN Result
),
[Name],
[Allowance],
[Start Month],
[End Month]
)Thank you soooooo much for the solution which solve my problem and give me more insights for the new function with VAR😊