Forum Discussion

sshweky's avatar
sshweky
Icon for Helper III rankHelper III
10 years ago

Previous Years vs Current Year

Hi,   I want to compare current year's sales vs last year's sales. I am not 100% clear on how time intelligence features work.   I have a "Years" that has the year, year beginning date & year end...
Hikmer's avatar
Hikmer
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Can the same be accomplished when using a Multidimensional OLAP Cube?

jblackshear's avatar
jblackshear
Icon for Advocate III rankAdvocate III
9 years ago
Hikmer wrote:

Can the same be accomplished when using a Multidimensional OLAP Cube?

 

I haven't used OLAP cubes in Power BI yet, so I can't answer in detail.

 

The only things that are required, as far as I know, are data with a date, a Dates or Calendar table with no missing dates, and a data model that joins these two. If you load the cube data into your Power BI data model and model the relationship to the Calendar table, I expect it would be treated the same.

 

  • Hikmer's avatar
    Hikmer
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    The issue I am facing is similar to this post, if I add a filter for year thne I no longer see a year over year percentage calcualtion.  I beleive I need the previous year to still be exposed while still allowing for the visualization to "slice" on the year but not filter on the year so that previous year data can be calcualted.  See below

     

     

     

    • michellemetzger's avatar
      michellemetzger
      New Member
      8 years ago

      Hello Hikmer,

       

      It appears that you may have set the Subtotal value for the year to not show.  Check your Visualization properties.

       

      Also, please post your function and full screenshot of the report page so that we can get a better idea of what you are working with.

       

      Thanks!