Forum Discussion

jakaihammuda's avatar
jakaihammuda
Helper III
2 years ago
Solved

DAX logic based on refresh failures or inprogress

Hello, I have a basic 3 column table. However the logic i want to implement i cant quite figure out.   Essentially all i want to do is the following: If the [statusname] of a report is either F...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Dangar332's avatar
    Dangar332
    2 years ago

    Hi, jakaihammuda 

    try below

    latest status = 
var a = MAXX(all('status'[Load Start Timestamp]),'status'[Load Start Timestamp])
VAR b = MINX(FILTER(ALL('status'),'status'[Entity Name]=MAX('status'[Entity Name]) && 'status'[Load Start Timestamp]=a),
           'status'[Status Name]
        )
var c = MAXX(FILTER(ALL('status'),'status'[Status Name]="succeeded" && 'status'[Entity Name]=MAX('status'[Entity Name])),
          'status'[Load Start Timestamp])
var d = IF(b<>"succeeded",c)
RETURN
d

     

     

     

Dangar332's avatar
Dangar332
Resident Rockstar
2 years ago

Hi, jakaihammuda 

try below

latest status = 
var a = MAXX(all('status'[Load Start Timestamp]),'status'[Load Start Timestamp])
VAR b = MINX(FILTER(ALL('status'),'status'[Entity Name]=MAX('status'[Entity Name]) && 'status'[Load Start Timestamp]=a),
           'status'[Status Name]
        )
var c = MAXX(FILTER(ALL('status'),'status'[Status Name]="succeeded" && 'status'[Entity Name]=MAX('status'[Entity Name])),
          'status'[Load Start Timestamp])
var d = IF(b<>"succeeded",c)
RETURN
d

 

 

 

jakaihammuda's avatar
jakaihammuda
Helper III
2 years ago

Dangar332, Amazing!! You have made my day and taught me a valuable new skill in DAX!

Thank you very very much for taking the time to help me on this 🙂

Wishing you a fantstaic new year!