POWER BI: Modeling

Time Intelligence Functions


Returns a single column table of dates shifted back one year.

Example Formula:

Find revenue for last year.

                   SamePeriodLastYear_revenue = CALCULATE(SUM(TransactionData[Revenue]),SAMEPERIODLASTYEAR(CalenderDate[Date]))

Power BI Demo:

How to Make:
  • In Power BI Desktop create a new measure using the formulas above.
  • Under visualizations select table
  • Select or Add in the date column (i.e CalenderDate[Date]) from the calendar date table.
  • Select or Add in the new measures to the values section

Additional Comments:

This does the exact same thing as DATEADD((CalenderDate[Date]),-1, YEAR)

  • SEO
  • Online Advertising
  • Online Ordering For Restaurants
  • Data Analytics

  • External Resources 4 Developers
  • CSS Tricks
  • MDN

  • Dash-Intel is a Power BI and Tableau resource site for data visualization and building BI dashboards.

    Data Analytics consultants in Edmonton, Alberta specializing in Tableau and marketing analytics

    Copyright 2021 Dash-Intel.com Terms / All rights reserved.
    Powered By The Order Guys