Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Data Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more

Reply
Kadrimedquali
Helper I
Helper I

subtract between two rates

‎01-20-2022 12:47 AM

Good morning all,

please i have a problem in power bi desktop,

i have a table matrix, I want to subtract between two rates, but the first is in the rows and the second is in the values.

example in this picture : 

 

Capture d’écran 2022-01-20 094517.png

Labels:
Message 1 of 6
1,109 Views
0
1 ACCEPTED SOLUTION
Samarth_18
Community Champion
Community Champion

‎01-20-2022 02:35 AM

Hi @Kadrimedquali ,

 

Can you try below code:-

Measure = [Taux Freinte] - MAX(table[column in a row})

 

Thanks,

Samarth

 

Best Regards,
Samarth

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin

View solution in original post

Message 5 of 6
1,049 Views
0
5 REPLIES 5
Samarth_18
Community Champion
Community Champion

‎01-20-2022 02:35 AM

Hi @Kadrimedquali ,

 

Can you try below code:-

Measure = [Taux Freinte] - MAX(table[column in a row})

 

Thanks,

Samarth

 

Best Regards,
Samarth

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin

Message 5 of 6
1,050 Views
0
Kadrimedquali
Helper I
Helper I
In response to Samarth_18

‎01-20-2022 02:51 AM

@Samarth_18 

 

Many thanks for your collaboration.

Best regards.

 

Message 6 of 6
1,045 Views
0
Kadrimedquali
Helper I
Helper I

‎01-20-2022 02:25 AM

@amitchandak please i need your help 

thanks

Message 4 of 6
1,053 Views
0
Kadrimedquali
Helper I
Helper I

‎01-20-2022 01:45 AM

Please i need help

Message 3 of 6
1,064 Views
0
Kadrimedquali
Helper I
Helper I

‎01-20-2022 12:49 AM

the column (Taux Freinte) is a dax formula also

Message 2 of 6
1,106 Views
0

Helpful resources

Announcements
Fabric Data Days is here Carousel

Fabric Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All