Single and multiple URL parameters

  1. Add columns to the Product and Date dimension queries that don't contain spaces:
let Source = AdWorksProd,FinDate = Source{[Schema = "BI", Item = "vDim_FinDate"]}[Data],CalYearStatusColumn = Table.AddColumn(FinDate, "CalendarYearStatus", each [Calendar Year Status], type text)in CalYearStatusColumn
  • An additional M expression with the Table.AddColumn() function creates a column in each dimension table query that doesn't contain spaces (for example, CalendarYearStatus)
This additional column can also be created in the SQL view accessed by the M query. If rights to the source SQL view are available, this is where the new column should be added.
  1. From the Data View in Power BI Desktop, right-click the new ...

Get Microsoft Power BI Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial