Forum Discussion

emmanuelkamara1's avatar
emmanuelkamara1
Helper I
6 years ago
Solved

Need help please.

I am struggling to write a Dax function that returns the outstanding balance after doing some filtration. In the dataset below, I want to get the outstanding balance after doing this filtration (curr...
a da
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    emmanuelkamara1 - 

     

    I believe the DAX should be something like:

     

    Measure = 
  VAR __Table = 
    ADDCOLUMNS(
      'Table',
      "Selector",(TODAY() - [registration_date_utc]) * 1. - [upfront_days_included]
    )
RETURN
  SUMX(FILTER(__Table,[Selector] >= 30),[Outstanding_balance])
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago
Great!