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])))
parry2k's avatar
parry2k
Super User
2 years ago

_power_bi not sure what you are trying to do but try this measure and go from there

 

  CALCULATE(
    SUM('Transfers'[QUANTITY]),
    'Transfers'[Direction] = "Out",
    'Transfers'[SimpleFilter] = 0,
    USERELATIONSHIP(Dim_Date[Date], 'Transfers'[Due_Date]),
    FILTER(
        ALL ( Dim_Date[Date] ), 
        Dim_Date[Date] <= MAX ( Dim_Date[Date] )
     
    )
)