Forum Discussion
last 3 Days Variance per ID
Hi all, I have a dataset of ID, Date, and value. I am trying to calculate the last 3 values of ID based on the last 3 dates. So once we get the last 3 values based on these trying to write ...
Can you post your source example data as text? That's a lot to type manually.
Hi Greg,
Thanks for the reply. Below are the sample files.
Sample excel file: https://www.dropbox.com/s/umb808dhuay7jjw/Sample.xlsx?dl=0
Sample pbix : https://www.dropbox.com/s/7p5a9ba0g9znac6/Sample.pbix?dl=0