Forum Discussion

ntaylo06's avatar
ntaylo06
Resolver II
7 years ago
Solved

Getting Data From Previous Row Based On Two Criteria

I have have the table 'Data' with the fields 'employee ID', 'rotation number', and 'location' with each employee ID appearing three times with rotation number increasing each time and a location code...
Need Help
  • ntaylo06's avatar
    ntaylo06
    7 years ago

    HotChilli Thats alright, I found a workaround solution by adding an index column and then calculating index-1 from it. Thanks for trying, though.

HotChilli's avatar
HotChilli
Community Champion
7 years ago

Do you want to link your pbix here and i'll have a look at it?

ntaylo06's avatar
ntaylo06
Resolver II
7 years ago

HotChilli Thats alright, I found a workaround solution by adding an index column and then calculating index-1 from it. Thanks for trying, though.

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    7 years ago

    ntaylo06 

     

    Glad to hear that. You may help accept the solution above. Your contribution is highly appreciated.