percentage differnce in power bi

[NISHA_S]

here am sharing my pbx file for refernce...I tried to find percenatge differnce with these existing data...but i failed...plse help me to solve the problem

https://www.dropbox.com/s/vr0u7wmyw5m6cv5/test.pbix?dl=0

[Jihwan_Kim · Accepted solution]

Hi, @NISHA_S 

Please check the link down below.

I suggest creating a dim-calendar table shown in the sample pbix file.

https://www.dropbox.com/s/9asrdz3mjjcl90z/test%20%281%29.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.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[NISHA_S]

Thanks ....A small doubt...In these scenario instead of monthly i have quarterly or yearly means how we calcualte percenatge difference?

[Jihwan_Kim]

Hi, @NISHA_S 

Thank you for your feedback.

I suggest having a proper Dim-Calendar Table. Then it will help a lot when creating time-related calculation measures.

For instance, proper dim-calendar table contains, Date / week / month / quarter / year / dayname / and many other date&time related columns in order to meet many requirements. 

If you need to create measures for quarter-related or year-related calculations, then it is better to have a proper dim-calendar table. 

You can easily search "DAX to create Calendar Table" and it will show quite a lot of ways how to create it. And you can select one of them that suits your organization's needs. For instance, if your organization has its own fiscal period, then you can select the one that creates the fiscal period-related columns.

Thanks.

Thank you.