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]))
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi BhaveshPatel

Thank you for your reply.

But this is not what I want. When I select nov 2 in date slicer, I want to show the Qty for nov 2 only. In your output, the Qty for category X is 83. But I want to display 43 when I select nov 2 in date slicer. Please see below:

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:)