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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Kadrimedquali
Helper I
Helper I

affiche the percentage 100%

Hello everyone,

 

i have a table and i wante to affiche the percentage100%

 

for example : in the 5 line the (evolution en %) is 100% but is not affiche in the column.

Kadrimedquali_0-1654596171334.png

 

thanks for your help.

1 ACCEPTED SOLUTION
AntonioM
Solution Sage
Solution Sage

Hi, 

 

It looks like you're using Delta / C 20 -21. The gaps are whenever you have blank C 20-21

 

Try using DIVIDE:

Evolution en % = DIVIDE( [Delta], [C 20-21], 100%)

 

 

 

(although I might argue that isn't strictly a 100% increase)

View solution in original post

3 REPLIES 3
Kadrimedquali
Helper I
Helper I

Thank tou for your help 

AntonioM
Solution Sage
Solution Sage

Hi, 

 

It looks like you're using Delta / C 20 -21. The gaps are whenever you have blank C 20-21

 

Try using DIVIDE:

Evolution en % = DIVIDE( [Delta], [C 20-21], 100%)

 

 

 

(although I might argue that isn't strictly a 100% increase)

ghoshabhijeet
Solution Supplier
Solution Supplier

@Kadrimedquali  Would appreciate if you could share some sample data or sample pbix file for your query. Thanks

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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