Forum Discussion
Countifs for table using related table
Hi all, I have two tables and need to create a relationship between both based on multiple columns Each column in the DATA table is a specific drive time to a location. I would like to...
Maybe an approach would be to create an index column in your 0-15, 15-30 etc table starting at zero, and then for each relevant item in your data table, you could create a measure using the quotient function dividing by 15, which'll then correspond with the index column?
Thanks jthomson. Can you give me an example of how that would work? I'm still very new to BI and DAX.
I think that would also fall down with your desire not to have many different measures etc for each time column you have unless I'm missing a quick way to duplicate the function, I'm mostly thinking of a quick way to find something that'll correspond with your time groups table