Forum Discussion
Solved
Translate SQL WHERE clauses to a query
Hi all! I have a very simple model with 2 tables - one fact with cases and history and one date dimension in SSAS. I need a measure to count open cases at the start of each contextualized period. So ...
johnsmith92 , if you do not have an active join between two tables then you do not need a crossfilter. Make both join inactive
Hi amitchandak. Thanks for your prompt reply! Unfortunately we are running SQL Server 2014, so I cannot use the CROSSFILTER function. Is there another way to write it?
johnsmith92 , if you do not have an active join between two tables then you do not need a crossfilter. Make both join inactive