Working with 2 time dimensions

[bwelsh]

So I have two seperate quality measures I track from week to week. 

Quality Measure 1 - Weekly Quality is measured Sunday - Saturday

Quality Measure 2 - Weekly Quality is measured Thursday - Wednesday

I have a data dimension table with a week end date column with the end date being each Sunday

My question is 1) How can I calculate both of these measures at the same time? 2) How can I display both of these on a visualization with the Weed End Date as the access?

[Phil_Seamark · Accepted solution]

Hi @bwelsh

One idea is to have a single date table (with one row per date), but have a column for each Week ending

Something like this calculated table :

Dates = ADDCOLUMNS(
            CALENDAR(DATE(2016,1,1) , TODAY()) ,
            "Weekday Name" , FORMAT([Date],"DDDD") ,
            "Week Ending Saturday" , [Date] + (7-WEEKDAY([Date])) ,
            "Week Ending Wednesday" , VAR X = 7-MOD(WEEKDAY([Date])+3,7)RETURN [DATE] + IF(X=7,0,X)
            )

Then just connect the Date column to your fact table and use  the Week Ending columns on your Axis

[bwelsh]

This is what I was thinking, thanks for the confirmation!