Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Variances between columns

 

 

Trying to replicate something that is easy in excel. Each month the business I work for do a 12 month revenue forecast and we compare forecasts. My stakholders want the ability to select any 2 forecasts and for the table to give varainces between the 2 selected forecasts.

 

So in the example below the forecast submitted in July 2017 and submitted in November 2017 have been selected. I have this working in Power BI, however the how do I create a dynamic measure that gives the variance based on what was selected?

 

  Submission Month 
  Jul-17Nov-17 
  RevenueRevenueVariance
Forecast MonthAug-17 $    977,976  
Sep-17 $    993,591  
Oct-17 $    979,292  
Nov-17 $ 1,057,841  
Dec-17 $    981,192 $    979,631-$   1,561
Jan-18 $    990,874 $    993,006 $    2,132
Feb-18 $ 1,016,939 $ 1,004,626-$ 12,313
Mar-18 $ 1,020,473 $ 1,015,008-$   5,465
Apr-18 $ 1,167,460 $ 1,135,328-$ 32,132
May-18 $    982,489 $    977,033-$   5,456
Jun-18 $    983,388 $    951,256-$ 32,132
Jul-18 $ 1,009,297 $ 1,009,132-$      165
1 ACCEPTED SOLUTION
Anonymous
Not applicable

Ok so that tells me that for each ForecastMonth, the First and Last Date are coming back with the same date.  On the brightside, that suggests that the formula overall is working. Its now a matter of understanding why, on a row by row context, we are only seeing a single Submission Month date.

View solution in original post

18 REPLIES 18

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.