it really depends on your data model, and the dimensions you are using. if you didnt create a bridge and used a date in the table then these two expressions wont go together. you may want to supply more info for others to help you, the data model would help a lot
Hi, I have only one kind of date, why do i need a datebridge ? Until tomorrow that i will be able to again revisit the model, i can describe it. There is one main table with ids and a date and a type field. I left joined on id this other table and because i needed to count the distinct ids in the second table i created m_id. Pretty much that is how the model looks for every type.