Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Date Filter

Hi All,  I have two tables like below: I created a relationship between two tables using ProductID. Then I created the following table and added a date slicer. My output is shown below. ...
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    Anonymous

     

    hi, you can obtain with this: 

     

    TargetAll = CALCULATE(SUM(Table1[Target]),ALL(Table2[Date]))
Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

Anonymous

 

hi, you can obtain with this: 

 

TargetAll = CALCULATE(SUM(Table1[Target]),ALL(Table2[Date]))
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Vvelarde,

It worked. Thank you very much:)