Forum Discussion

cfstout's avatar
cfstout
Regular Visitor
4 years ago
Solved

DAX equivalent to excel Array

Hi, I have an excel array formula that I need help in writing the DAX eqivalent. Columns Station ID Start Time End Time My formula captures the start time of next start per Station ID. Next St...
array
DAX
smpa01's avatar
smpa01
Community Champion
4 years ago

cfstout  you can use a measure like this

NextStart = 
CALCULATE (
    MIN ( 'tbl'[Start Time] ),
    'tbl'[Start Time] > MAX ( 'tbl'[Start Time] ),
    ALLEXCEPT ( 'tbl', 'tbl'[Station ID] )
)

 

 

 

cfstout's avatar
cfstout
Regular Visitor
4 years ago

Hi, thanks for the response. 

I am unable to get this to work... would you mind attaching the .pbix file so I can see how you created the VAR?

tks/