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
Mahamood0218
Helper II
Helper II

how to divided two fields in measure dax function.

Hi PBI experts,

 

i am new to PBI ,I have two fields "Tax Amount" and Local Currency, i want to find out measure dax function i.e "Divided function"

Mahamood0218_1-1670481769970.png

 

example : divide function = 7800/82.56 = 94.47 it should be new measure column.

could you please guide me.

 

 

2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

@Mahamood0218 a new measure

 

sumx(Table, divide([Tax Amount], [local Currency])

View solution in original post

Mahesh0016
Super User
Super User

Mahesh0016_0-1670486803385.png

Hello @Mahamood0218 ,
I hope It is Helpful for you.

View solution in original post

3 REPLIES 3
Mahamood0218
Helper II
Helper II

@amitchandak  thank you ,now formula is working

Mahesh0016
Super User
Super User

Mahesh0016_0-1670486803385.png

Hello @Mahamood0218 ,
I hope It is Helpful for you.

amitchandak
Super User
Super User

@Mahamood0218 a new measure

 

sumx(Table, divide([Tax Amount], [local Currency])

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.