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...
kaszab10's avatar
kaszab10
New Member
3 years ago

Hi Erika_S ,

 

I had a very similiar problem in the last days. I have an unioned date table and a dataset tablet. I created a Many-Many connection between them and this filter helped me solve it.

 

In your example:

Same Period LY = CALCULATE([Total tickets], ALLCROSSFILTERED('Dates'), SAMEPERIODLASTYEAR('Dates'[Date]))

 

I hope it can help for you as well!