Further reading

• Discovering Power BI:
• Power BI data sources:
• The calculate() DAX function:
• DAX formula to filter ad_noofflights for the first of the month:

  FirstofMonthSum = calculate(sum(Query1[ad_noofflights]), Query1[ad_dayofmonth]=1)

• DAX deep dive readings:

  a) Alberto Ferrari, Marco Russo, and Daniele Perilli:

  b) Chris Webb's BI blog:

  c) Adam Saxton, aka Guy in a Cube:

  d) DAX reference documentation:

• Data model optimization:
• Differences between Power BI and Azure Analysis Services:
• Data Share source-to-target mapping:
• Azure Data Share: https://docs.microsoft.com/en-us/azure/data-share/overview