Forum Discussion

MrCoyado's avatar
MrCoyado
Frequent Visitor
9 years ago
Solved

Time Intelligence - Comparing Day of Week

Hi everyone!   I am working with Power BI for awhile now and we are slowly migrating our KPIs from the good old Excel to Power BI. One type of comparison we often make is comparing a day of week t...
Need Help
Tutorial Requests
  • MrCoyado's avatar
    MrCoyado
    9 years ago

    Hello Anonymous and TomMartens!

    Thanks for your contributions, it helped me a lot.

     

    I used both of your ideas to combine it with my own. Using the Index, I could create the comparisons within a certain date range.

    For Easther though, I still need to create the date alignment differently, since it's a fixed date which I need to compare to my previous Easter (we have a 45 day calendar for this campaign), that's where a Dim_Calendar_Campaign helped me out. There I can fix the dates I want to compare (2017-04-16 x 2016-03-27), using the Index to indicate whether the date is in the actual year or in the previous year.

MrCoyado's avatar
MrCoyado
Frequent Visitor
8 years ago

Hi rosre075!

I might be mistaken, but leap years should be a problem with this formula.

Check out if the result works when you have a leap year.

rosre075's avatar
rosre075
Frequent Visitor
8 years ago

MrCoyado Thanks for your feedback. Since my purpose is to compare say the current Monday vs the Monday of the same period last year, I think this dateadd - 364day formula should be fine.

 

By the way, I found that the dayweek index suggested earlier is really handy and I have used it as the x Axis variable in the visual for this LY measure vs current value. 

 

Thank all for your valuable advices :)

 

Rebecca