Set Analysis Senario

[bhaminiparmar]

Hello Everyone,
this is a Set Analysis scenario-based question
can anyone answer this question?


I have two tables that are not linked so if I make a selection eg. Today's date is 13th so if I filter out the data then it should get the date on a selection basis. (Set analysis scenario)

[JandreKillianRIC]

HI @bhaminiparmar 

If you only select one date you can use something like this

Sum({<Table1Date = {"$(=Table2Date)"}>} Sales)

If you are selecting more than one date (More like a range) it would be something like this 

Sum({<Table1Date = {">=$(=Min(Table2Date))<=$(=Max(Table2Date))"}>} Sales)

For this it will select the date in Table1 based on the selection of Table2. 

Regards - Jandre