Power BI – To get calculated table with more than 1 row

 Power BI – To get calculated table with more than 1 row

 
=UNION ( 

  

  

SELECTCOLUMNS( 

'Analysis Period', 

"Start Date", DATE(YEAR(TODAY()-1-365), 1, 1), 

"Analysis Period Selected", "YTD", 

"End Date", Today()-1-365), 

SELECTCOLUMNS( 

'Analysis Period', 

"Start Date",DATE(YEAR(TODAY()-1-365), MONTH(TODAY()-1-365), 1), 

"Analysis Period Selected", "MTD", 

"End Date", Today()-1-365), 

SELECTCOLUMNS( 

'Analysis Period', 

"Start Date",Today()-1-365, 

"Analysis Period Selected", "D-1", 

"End Date", Today()-1-365) 

)