Forum Discussion
Solved
DAX - Crossjoin with Criteria
I have been asking Copilot but without success so coming to the real experts! I have two tables, one called 'BrandForecast' and the other 'Running Calendar'. I am trying to figure out how to do a...
create a calculatedtable as below :
filter (
crossjoin ( table1 , table2 ) ,
[Week Starting (Monday Start) >= [Promotion Start Date] && [Week Starting (Monday Start) <= [Promotion End Date]
)
hope this helps .
create a calculatedtable as below :
filter (
crossjoin ( table1 , table2 ) ,
[Week Starting (Monday Start) >= [Promotion Start Date] && [Week Starting (Monday Start) <= [Promotion End Date]
)
hope this helps .
Appreciate it! I was trying =calculatetable(crossjoin(... and it wasn't working. Simpler is better!