Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone
I have a problem and I can not solve it.
I have a table like this:
I need to build a graph with a sum of deviation in relation to previous month. To count the deviation I need to consider always the max – min between the current month and the previous month
For example, to February:
And finally, I need to create the chart like this:
I am trying but probably I am doing something wrong-
Does someone help me?
Solved! Go to Solution.
@Anonymous
Create a Date table as it will help you with the time intelligence functions. Check the attached file.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi, @Anonymous
I suggest having a dim-calendar table like below.
please check the below picture and the sample pbix file's link down below.
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.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, @Anonymous
Please check the below.
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.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, @Anonymous
I suggest having a dim-calendar table like below.
please check the below picture and the sample pbix file's link down below.
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.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thank you so much.
I tried to do your advice but insted of create a measure I am creating a column using dax to add on table the desviation column but your rule doesn´t work.
Could you please explain me why?
Thanks
Hi, @Anonymous
Thank you for your feedback.
I think you cannot use the formula for creating a column that is for creating a measure.
how does your expected outcome look like?
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
I would like to create a new column with desviation as your measure do. I want to create a columns like this:
Hi, @Anonymous
Please check the below.
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.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
@Anonymous
Create a Date table as it will help you with the time intelligence functions. Check the attached file.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hey @Anonymous ,
you can calculate the value from the last month and subtract that from the current month:
Deviation Last Month = SUM( myTable[No of Sales] ) - CALCULATE( SUM( myTable[No of Sales] ), DATEADD( myTable[Date], -1, MONTH ) )
This should work for your case.
Hello
Thanks, but you resolution doesn´t work.
User | Count |
---|---|
93 | |
83 | |
77 | |
71 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |