cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

How to find year growth percentage using DAX

Hello Experts ,

 

I want to write DAX query from the below calclulation .Please advise me how to do using DAX. Actually i am using (AdventureWorksDW2017   data from this db how to find year growth as a percentage )

 

((currentyear-Last year) / (Last year ))*100

1 ACCEPTED SOLUTION
natabird3
Continued Contributor
Continued Contributor
1 REPLY 1
natabird3
Continued Contributor
Continued Contributor

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors