Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Calculate Latest Transaction Date Time

  Need the correct way to Calculate LastTransaction Date Time --What i have written, Time also should be added to date. LastTransactionDateTime = CALCULATE( max((D_SalesHeader[SalesTransactionDat...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

You are trying to "filter up" from the sales fact table into the sales header dimension table. It would be much simpler to add the transaction timestamp to the fact table.

 

see attached