Forum Discussion
Difference between two rows
Hi, Hijbul_Bari
Please correct me if I wrongly understood your question.
In my opinion, if you want to achieve this by writing a measure, there have to be some criteria that tell Jan is earlier than Feb, and Feb is earlier than Mar.
I just assumed this and created a sample by myself.
If the below sample (link down below), does not suit your case, please share your sample file's link, then I can try to look into it and come up with a more accurate measure.
The measures that I used are in my sample pbix file.
https://www.dropbox.com/s/3fa608ymcfd9zcq/Hijbul%20Bari.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Thanks a lot. Your concept is right. But I don't have any Date table. The Month Name is a nothing but a "Text" like Jan, Feb etc came from Raw data. Is it possible without date/time intelligent fuction, get the same output using any other function like "Earlier"?
For better understanding if I remove Month and bring product column then output should be the following way. Means it always compare upper two rows and give the Percentage Change.