How can we improve Power BI?

Quick measure: Difference in % / a reference

Quick measure: Difference in % / a reference: select previous reference
In a matrix that has several columns for several years, would like to get for each column (year),the difference in % versus not 1 reference as currently, but each time versus the previous column (year)

9 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

arnaud shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
  • Jen Scanlon commented  ·   ·  Flag as inappropriate

    I thought this would definitely be possible in power BI but I haven't been able to find a way to create a new measure that represents the percent difference from the previous date member (in my case Year Month). I tried to create a new column that represented the measure value of the previous member, and tried editing the query using the advanced editor and am still stuck with using % difference from filter member, so I will have to manually update the month and filtered data every month.

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.