Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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...
Need Help
  • johnt75's avatar
    johnt75
    1 year ago

    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]
)