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? 

     

     

     

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

    CNENFRNL When i do the same dax for same period last year- for one of the tables that I used in the Union, all is fine, returns the correct results, no problem. But for some reason Unioned table just does work. Maybe there are issues doing dax between dates table and unioned tables that i am not aware off?