Forum Discussion
Fetching values from previous month
Hi, Wahid777
Please check the below pictures.
It is better to have Dim-Date-Table in order to conveniently use the time-intelligent-DAX-function in Power BI.
And the connection between the two tables is needed.
All measures are in the sample pbix file's link down below.
https://www.dropbox.com/s/3m2d6kqk7rjn501/Wahid777.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.
Hi, Wahid777
Please check the below pictures.
It is better to have Dim-Date-Table in order to conveniently use the time-intelligent-DAX-function in Power BI.
And the connection between the two tables is needed.
All measures are in the sample pbix file's link down below.
https://www.dropbox.com/s/3m2d6kqk7rjn501/Wahid777.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.
Thank you
I understand the sorting of the table was a mess but i was only able to get it this way from the database. You're table dimension is the perfect approach to this.
However, since I couldn't change the table, I was able to export the data to excel and used pivot table there to arrange them seperately and used another similar table to calculate the MoM variance % using the first table (transformed using pivot table) as the data source.