cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

Variance Help

Hi All:

I have the below data set that references volunteerism in January of 2016 & 2017. Can someone show me how to get the variance to display. I want to see that the difference between hours volunteered in 2016 & 2017 is '1186'. 

 

image 7.19.17.docx.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Variance Help

@nmck86,

Create a column using DAX below.

variance = 
var previous= CALCULATE(MAX(Table2[Volunteer Hours]),FILTER(Table2,Table2[Month in Year]=EARLIER(Table2[Month in Year])&& 'Table2'[Year]<EARLIER('Table2'[Year])))
return
 IF(ISBLANK(previous),0, 'Table2'[Volunteer Hours]-previous)

1.PNG

If you get any issues, please share table structure with raw data. 


Regards,


Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Highlighted
Microsoft
Microsoft

Re: Variance Help

@nmck86,

Create a column using DAX below.

variance = 
var previous= CALCULATE(MAX(Table2[Volunteer Hours]),FILTER(Table2,Table2[Month in Year]=EARLIER(Table2[Month in Year])&& 'Table2'[Year]<EARLIER('Table2'[Year])))
return
 IF(ISBLANK(previous),0, 'Table2'[Volunteer Hours]-previous)

1.PNG

If you get any issues, please share table structure with raw data. 


Regards,


Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Post Patron
Post Patron

Re: Variance Help

2017-08-01_10-48-19.png

 

for some reason this formula isnt working or recognizing my table for calendar? I have the hours information that you seen in my original post and I have a table that I built that has the calendar details... do you know what could be causing this to arise?

Highlighted
Microsoft
Microsoft

Re: Variance Help

@nmck86,

Right click your table, select New Column and put the DAX there.

Regards,

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Kudoed Authors