Power BI Tips

https://powerbi.microsoft.com/en-us/blog/best-practice-rules-to-improve-your-models-performance/  

The calculated table is related to the Financial Summary table via the Fi nancialSummaryLineTypeId column. The Destination Category column is added to the rows in a Matrix to summarize the measures Sales Detail Destination Categories = UNION(     CALCULATETABLE(         SELECTCOLUMNS(             'Financial Summary Line Type',             "FinancialSummaryLineTypeId", 'Financial Summary Line Type'[FinancialSummaryLineTypeId],             "Destination Category", 'Financial Summary Line Type'[Destination Category]         ),         'Financial Summary Line Type'[Destination Category] IN { "Carry Out", "Delivery", "Dine In", "Drive Thru" }     ),  ...

https://www.sqlbi.com/articles/introducing-calculation-groups/  

https://www.youtube.com/watch?v=AGrl-H87pRU  

  https://radacad.com/row-filtering-in-power-bi-and-power-query-remove-blank-rows-vs-remove-empty

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

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

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

  https://www.youtube.com/watch?v=ax_vEj5JbEU&t=12s

https://www.havensconsulting.net/blog-and-media/toggling-report-page-tooltips-with-bookmark-buttons  

Grouping Report Objects in Power BI 

https://www.havensconsulting.net/blog-and-media/grouping-objects-for-better-bookmarking   The Bookmarks only set Display and Selected Visuals.

Power Query: New Source, Blank Query, Advanced Editor Copy the following code into the Advanced Editor: let     Source = DateTime.LocalNow(),     #"Converted to Table" = #table(1, {{Source}}),     #"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "DateTime"}}),     #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"DateTime", type datetime}}) in     #"Changed Type"

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

https://www.youtube.com/watch?v=8Mvr_AIw2DU  

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

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

https://www.youtube.com/watch?v=L-rGuFCOn18  

https://www.youtube.com/watch?v=0QvovI3aycs  

https://www.sqlbi.com/articles/all-the-secrets-of-summarize/  

  https://www.youtube.com/watch?v=9wN33rTaiB4 Gives example using a bridge table as well as the LOOKUP function.

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

  https://www.sqlbi.com/articles/introducing-summarizecolumns/