Forum Discussion

Erika_S's avatar
Erika_S
Icon for Helper I rankHelper I
5 years ago

Union Table and date table relationship

Hi guys, I hope maybe you can help me.    I created a Dax dates table. Like this: Dates = ADDCOLUMNS( CALENDAR (DATE(YEAR(MIN('Looker Union'[Creation period datetime])),1,1), DATE(YEAR(MAX('Looker...
CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
5 years ago

Hi, Erika_S , without a glance at your whole data model, it's hard to pinpoint the cause of issue. An attachment of mockup pbix file surely helps a lot.

Is "YearQuarter" a column from Dates table? Any other filters (directly/indirectly) affect this viz?

Erika_S's avatar
Erika_S
Icon for Helper I rankHelper I
5 years ago

Yes, YearQuarter from Dates table. There is literatly nothing else going on (no filters, no other dax (yet) 🙂 ) 

If needed ill create a mock up file as well. 

 

But the Dax for same period looks correct, right?