Forum Discussion

arnomics's avatar
arnomics
Helper I
2 years ago
Solved

Use previous Row Date & Current Row Date to create range for calculation

Hi all,   I've been trying to crack this specific requirement.   I currently have a Table Visual with Date from Date Column. I've got the below Measure which concatenates Payment info from Paymen...
Need Help
  • arnomics's avatar
    arnomics
    Helper I
    2 years ago

    Thanks heaps . That worked like a charm.This was my Measure Offset Measure = CALCULATE([TSET], OFFSET(-1,ALLSELECTED(Date'[Date])))However, I have a question. Below is the Offset Measure on a Visual.  Why is the first row for 2023 blank? Ideally, we would expect to see 5/12/2022 12:00:00 AM. Any ideas? Thanks again!

    miTutorials