Power BI Tips

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

  https://www.youtube.com/watch?v=4-WSXQ6qLec

  https://www.youtube.com/watch?v=Nr-_difQ7vw

  https://www.youtube.com/watch?v=LKj4GLJA-lw

  https://www.youtube.com/watch?v=Tk-7gBt9CDE

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

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

  https://www.youtube.com/watch?v=EawkPc_iLs4&t=20s

  https://www.youtube.com/watch?v=9qKe66uBce8 Specify a column name for REMOVEFILTERS instead of a table.

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

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

  https://www.mssqltips.com/sqlservertip/6917/working-days-calculator-power-bi/?utm_source=dailynewsletter&utm_medium=email&utm_content=headline&utm_campaign=20210714

  RM Average Sales for Units With Sales > $0 = -- Get the UnitIds. VAR Units = VALUES('Unit'[UnitId]) -- Get the Fiscal Week Num Overall for the Current Fiscal Week. This will be -- an incomplete week (we always want the last completed week). On the Tuesday -- morning refresh, the Fiscal Week Num Overall will increment to the next week -- which has just begun. VAR FiscalWeekNumber = CALCULATETABLE(     SUMMARIZE(     'Calendar',     'Calendar'[Fiscal Week Num Overall]     ), ALL('Calendar'),     'Calendar'[Current Fiscal Week] = TRUE() ) -- Get the list of the last 9 Fiscal Week End Dates prior to the current one. -- This is the date range to check for Sales > $0. VAR FiscalWeekEndDates = CALCULATETABLE(     SUMMARIZE( 'Calendar', 'Calendar'[Fiscal Week End Date]     ), ALL('Calendar'),     AND(...

  https://blog.pragmaticworks.com/powerbi-dax-variables-calculate-and-filter Call CALCULATE while creating a calculated column. Use FILTER to create a table filter for CALCULATE.