Forum Discussion

_power_bi's avatar
_power_bi
Helper I
2 years ago
Solved

DAX question using two date columns and filtering

I am currently pulling blanks when I know there is data. Something is wrong with my DAX but I'm not sure. Any help is appreciated   I need a running total of the transfers[quantity] field to put in...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Hi,

    Does this measure work?

    =CALCULATE(SUM('Transfers'[QUANTITY]),'Transfers'[Direction] = "Out",'Transfers'[SimpleFilter] = 0,USERELATIONSHIP(Dim_Date[Date], 'Transfers'[Due_Date]),datesbetween(Dim_Date[Date],minx(all(Dim_Date),Dim_Date[Date]),max(Dim_Date[Date])))
Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

Does this measure work?

=CALCULATE(SUM('Transfers'[QUANTITY]),'Transfers'[Direction] = "Out",'Transfers'[SimpleFilter] = 0,USERELATIONSHIP(Dim_Date[Date], 'Transfers'[Due_Date]),datesbetween(Dim_Date[Date],minx(all(Dim_Date),Dim_Date[Date]),max(Dim_Date[Date])))