Calculating data between relations

[tomasjurasek]

Hi,

I have some questions about how calculate some data from different tables. 

For example i have relationship  1:M (Gym:Classes) and 1:M (Classes: Booking)

And i want gyms which have some booking in last 7/14 days.

What is good to use? Dax, UI?

Thanks

[v-shex-msft]

Hi @tomasjurasek,

Can you share some detail content of your struct?

BTW, I'd like suggest you add a calculated column to store the gym info, then you only need to deal with the specify date range.

Measure:

IsBooking Last 7 days = IF(COUNTROWS(FILTER(ALL(Booking),[Date]>= TODAY()-7&&[GYM ID]=MAX([GYM ID])))>0,TRUE(),FALSE()) 

Regards,

Xiaoxin Sheng

[Greg_Deckler]

Basic format is:

MyColumn = CALCULATE(SUM('Table'[Column]),RELATEDTABLE('Table'))

This would SUM the "Column" in Table but only for the related records from Table that relate to the particular row in the context of which this formula executes.