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

emmanuelkamara1 - So was my DAX formula correct because:

"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."

 

Unless I'm mistaken, that's what the DAX was doing.

 

Perhaps we need to backup. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      6 years ago
      Great!
  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    emmanuelkamara1 - One, I would try it as a Card visual. Two, what does See details say?