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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
netanel
Post Prodigy
Post Prodigy

Diff % and money

Hello everyone
I am trying to write two formulas 
one That will bring me the change in percentages and one in money
I'm not getting the right numbers,
Would appreciate help
Attaches the formulas

 

1. Diff $ = CALCULATE(SUMX('Revenues DB','Revenues DB'[Net USD average per Day]-'Revenues DB'[Net USD average per Day LM]))
 
2. Net USD LM % difference from Net USD average per Day1 =
VAR __BASELINE_VALUE = [Net USD average per Day]
VAR __VALUE_TO_COMPARE = [Net USD average per Day for Budget 2021]
Var _Variance = if(ISBLANK(__VALUE_TO_COMPARE),0,__VALUE_TO_COMPARE - __BASELINE_VALUE)
RETURN
DIVIDE(_Variance, __BASELINE_VALUE)







Did I answer your question?
Mark my post as a solution!
Appreciate your Kudos!

Connect on Linkedin
linkedin.com/in/netanel-shriki
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@netanel ,

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

The two need to measures no column

 

Diff $ = 'Revenues DB'[Net USD average per Day]-[Net USD average per Day LM]

 

Try for a second one

 

Net USD LM % difference from Net USD average per Day1 =
VAR __BASELINE_VALUE = [Net USD average per Day]
VAR __VALUE_TO_COMPARE = [Net USD average per Day for Budget 2021]
RETURN
DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE)

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@netanel ,

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

The two need to measures no column

 

Diff $ = 'Revenues DB'[Net USD average per Day]-[Net USD average per Day LM]

 

Try for a second one

 

Net USD LM % difference from Net USD average per Day1 =
VAR __BASELINE_VALUE = [Net USD average per Day]
VAR __VALUE_TO_COMPARE = [Net USD average per Day for Budget 2021]
RETURN
DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE)

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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