Power BI Tips

https://www.sqlbi.com/articles/show-previous-6-months-of-data-from-single-slicer-selection/  

https://www.sqlbi.com/articles/using-calculation-groups-or-many-to-many-relationships-for-time-intelligence-selection/  

https://www.youtube.com/watch?v=JYywNHCKhMk  

  https://www.sqlbi.com/tv/explaining-unexpected-results-with-dax-time-intelligence-functions-unplugged-n/

  https://www.youtube.com/watch?v=Ti9WtwClPeY

  https://www.youtube.com/watch?v=xCHnjzgfLG8

  https://www.havensconsulting.net/blog-and-media/creating-a-mtd/qtd/ytd-time-intelligence-slicer

 PARALLELPERIOD - gets the total for the prior year Sales PY = CALCULATE (     [Sales Amount],     PARALLELPERIOD ( 'Date'[Date], -1, YEAR ) )

 Year over Year % = VAR CYSales = [Sales Amount] VAR PYSales = [Sales SPLY]     -- sample period last year VAR Result = IF (     CYSales <> 0 && PYSales <> 0,     DIVIDE ( CYSales - PYSales, PYSales)     ) RETURN Result

 Sales Same Period Last Year Sales SPLY = CALCULATE(     [Sales Amount],     DATEADD (         'Date'[Date],         -1,         YEAR     ) Could also use SAMEPERIODLASTYEAR ( 'Date'[Date] )

Sales YTD =  CALCULATE (     [Sales Amount],     DATESYTD (         'Date'[Date]     ) )

 Dates on the rows in a year. month, day hierarchy. Calculate YTD Sales. Sales YTD = VAR LastVisibleDate = MAX( 'Date'[Date] ) VAR CustomYTD =     DATESBETWEEN (         'Date'[Date],         DATE( YEAR ( LastVisibleDate ),  1,  1 ),         LastVisibleDate     ) RETURN CALCULATE(     [Sales Amount],     CustomYTD  )