Forum Discussion

MPR's avatar
MPR
Icon for Advocate I rankAdvocate I
8 years ago
Solved

DAX Formula Showing Blank

Hello,   I have shared a folder with the pbix file and source file.  I hope you can access it.   Folder   I have a function in DAX that is killing me.  I have given up way too much time and sle...
Need Help
  • parry2k's avatar
    parry2k
    8 years ago

    MaxIndex was not getting calculated correctly,  so we calculate maxindex of the account you are inerested, same I did for other DAX

     

     

     

     

    Var BankAcct1 = "1008 · Chase Checking"
    Var MaxIndex = 
    CALCULATE(MAX('Sanitized Transaction Detail v2'[Index]),  
    'Sanitized Transaction Detail v2'[Account] = BankAcct1 )

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

MaxIndex was not getting calculated correctly,  so we calculate maxindex of the account you are inerested, same I did for other DAX

 

 

 

 

Var BankAcct1 = "1008 · Chase Checking"
Var MaxIndex = 
CALCULATE(MAX('Sanitized Transaction Detail v2'[Index]),  
'Sanitized Transaction Detail v2'[Account] = BankAcct1 )

 

MPR's avatar
MPR
Icon for Advocate I rankAdvocate I
8 years ago

parry2kPerfect.  Thanks for the eduction.  My maxindex statement wasn't being limited to my bank account.  

 

It works perfectly now.