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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
SHILL
Regular Visitor

Percentage Difference

I have the example graph below and I need to get a percentage that shows the difference against our start of year plan. For example, the start of the year plan we forecast a total of 30 sales, the Q1 plan forecasted a total of 37, which is 185% against the start of year plan. Then Q2 we forecast which is 300% against the start of year plan. Is there a measure I can use to get this

Plan Forcasted MonthTotals
Start of year JAN5
Start of year FEB10
Start of year MARCH5
Q1  JAN7
Q1  FEB10
Q1  MARCH20
Q2 JAN10
Q2 FEB20
Q2 MARCH30
1 ACCEPTED SOLUTION
Irwan
Solution Supplier
Solution Supplier

hello @SHILL 

 

please check if this accomodate your need.

 

Irwan_0-1720659848173.png

 

Create a measure wiht following DAX:

Calculate =
var _Status = SELECTEDVALUE('Table'[Plan Forcasted])
var _StartofYear = CALCULATE(SUM('Table'[Totals]),'Table'[Plan Forcasted]="Start of year")
Var _Q1 = CALCULATE(SUM('Table'[Totals]),'Table'[Plan Forcasted]="Q1")
var _Q2 = CALCULATE(SUM('Table'[Totals]),'Table'[Plan Forcasted]="Q2")
Return
IF(
    _Status="Start of year",
    "",
IF(
    _Status="Q1",
    DIVIDE(_Q1,_StartofYear),
IF(
    _Status="Q2",
    DIVIDE(_Q2,_StartofYear)
)))
Irwan_1-1720659896478.png
 
Hope this will help you.
Thank you.

View solution in original post

1 REPLY 1
Irwan
Solution Supplier
Solution Supplier

hello @SHILL 

 

please check if this accomodate your need.

 

Irwan_0-1720659848173.png

 

Create a measure wiht following DAX:

Calculate =
var _Status = SELECTEDVALUE('Table'[Plan Forcasted])
var _StartofYear = CALCULATE(SUM('Table'[Totals]),'Table'[Plan Forcasted]="Start of year")
Var _Q1 = CALCULATE(SUM('Table'[Totals]),'Table'[Plan Forcasted]="Q1")
var _Q2 = CALCULATE(SUM('Table'[Totals]),'Table'[Plan Forcasted]="Q2")
Return
IF(
    _Status="Start of year",
    "",
IF(
    _Status="Q1",
    DIVIDE(_Q1,_StartofYear),
IF(
    _Status="Q2",
    DIVIDE(_Q2,_StartofYear)
)))
Irwan_1-1720659896478.png
 
Hope this will help you.
Thank you.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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