Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

SSAS Tabular Model Date Range Join

Hi All,   I have a SSAS Tabular model on which my PBI reporting is based.   I have not found a way to join the tables using a range. Where the join is a "between"   Other reporting solutions ar...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks Zoe,

 

This looks really cool! Where do I apply the filter?

 

Is it applied in each sales measure? or can I globally apply it so that all measures that use the date table can be reported over a date range?

 

Thanks again

Basia

dax's avatar
dax
Community Support
7 years ago

Hi Basia

 

According to your description, it seems that you want to join two tables into a new table, so my expression is to create a new table, you could use the new table to create visual and apply filter on it

 

Best Regards,
Zoe Zhi

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    dax 

     

    Hi Zoe, 

     

    Thanks for your explanation.

    I guess I'm after a run-time table that would be used for the purpose of graphing all sorts of measures against a time line that is governed by a single drop down Month Filter/Slicer.

     

    I have not been able to achieve this yet.

     

    With your solution, I would need to create a separate measures table for each measure and I have 100+ measures, so that is just not feasible.

     

    I'll keep searching/asking....

     

    Thanks for your help.

     

    Basia