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])
emmanuelkamara1's avatar
emmanuelkamara1
Helper I
6 years ago

I want to calculate the potfolio at risk which is the outstanding balce for accounts that have been disabled for 30+ days divided by all the outstanding balnce of enabled and disabled accounts. When a user register an account, the user will get a minimum of 7 days to use the product before it switches to disbaled mode. However, the user will get more than 7 days to use the product if the upfront price is  grater than the minimum upfront price. To get an accurate Portfolio at risk, I will have to filter out new accounts because I will not know if they are bad or good customers that is why I needed to do some filteration. Before including an account in my PAR calculation, I need to make sure that the current date minus the registration date minus the upfront days is grater than or equal to 30.