Forum Discussion

mpalha04's avatar
mpalha04
Helper III
7 years ago
Solved

Filter Measure Based on Different Dates

Hello,   I want to calculate total revenue for clients starting from different ship dates. The client ID and corresponding ship date is from an Excel table and I created a relationship to my orders...
Need Help
  • mpalha04's avatar
    mpalha04
    7 years ago

    Thanks kgova, Ashish_Mathur,

     

    Simple fix I should have figured. Solution below:

     

    Measure = CALCULATE(SUM(Table1[order total]),FILTER(Table1,Table1[order date] > Table2 [ship date]))  )

kgova's avatar
kgova
Frequent Visitor
7 years ago

use below measure you will get the desired output

 

Measure = CALCULATE(SUM(Table1[order total]),FILTER(Table1,Table1[order date] > DATEVALUE("4/4/2017"))  )

 

mpalha04's avatar
mpalha04
Helper III
7 years ago

Thanks kgova, Ashish_Mathur,

 

Simple fix I should have figured. Solution below:

 

Measure = CALCULATE(SUM(Table1[order total]),FILTER(Table1,Table1[order date] > Table2 [ship date]))  )