Forum Discussion

lshelton's avatar
lshelton
Frequent Visitor
5 years ago
Solved

Tracking Growth on Changing Exchange Data

Greetings all,   I am pretty new to Power BI, and I was looking for assistance with a solution we developed for a client.  They were looking for a way to track Exchange meeting categories for emplo...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    Hi lshelton ,

     

    Based on your description, you need to create a disconnected calendar table as a slicer, and then create a measure to show the differences of the previous months.

     

    Here is a sample .pbix

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

lshelton's avatar
lshelton
Frequent Visitor
5 years ago

Hmm it doesn't look like a date table would work because there are more than one entry per day sometimes and some days don't have any entries.

  • dedelman_clng's avatar
    dedelman_clng
    Community Champion
    5 years ago

    Hi lshelton  - the Date table / Calendar table is designed for exactly that case.  The calendar has all of the dates, and it joins to a key date table on your fact/detail as a Many-to-1 relationship, so it's ok if there are gaps in the detail.  You then use the data from the Date table as your longitudinal axis and it automatically filters the detail.

     

    Take a look at this blog post about calendar tables: Time Intelligence Calendar Table 

     

    David