https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-multiplying-the-data-from-the-two-tables/m-p/1227789#M19983 <P>Hello</P><P>I'm begining with DAX and I try to create new measure with calculete price in euro; price in local currency from first table [sales] and currency form second [Currency].</P><P>Of course, the tables are connected in the model by the currency symbol column.</P><P>I can make join and add column with currrency in Sales table, but the better way is try to use measure.&nbsp;</P><P>&nbsp;</P><P>In excel loos like: Price in Euro = [sales]'Price in local currency' * xlookup([sales]"currency local" ; [Currency]"currency"; [Currency]"Ratio_EUR")</P> Thu, 16 Jul 2020 10:23:33 GMT Leski 2020-07-16T10:23:33Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-multiplying-the-data-from-the-two-tables/m-p/1227789#M19983 <P>Hello</P><P>I'm begining with DAX and I try to create new measure with calculete price in euro; price in local currency from first table [sales] and currency form second [Currency].</P><P>Of course, the tables are connected in the model by the currency symbol column.</P><P>I can make join and add column with currrency in Sales table, but the better way is try to use measure.&nbsp;</P><P>&nbsp;</P><P>In excel loos like: Price in Euro = [sales]'Price in local currency' * xlookup([sales]"currency local" ; [Currency]"currency"; [Currency]"Ratio_EUR")</P> Thu, 16 Jul 2020 10:23:33 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-multiplying-the-data-from-the-two-tables/m-p/1227789#M19983 Leski 2020-07-16T10:23:33Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-multiplying-the-data-from-the-two-tables/m-p/1227840#M19984 <P>Try something like:</P><P>&nbsp;</P><LI-CODE lang="php">= SUMX ( Sales, Sales[PriceInLocalCurrency Column] * RELATED ( Currency[Currency Column] ) )</LI-CODE><P>&nbsp;</P> Thu, 16 Jul 2020 10:48:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-multiplying-the-data-from-the-two-tables/m-p/1227840#M19984 AntrikshSharma 2020-07-16T10:48:36Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-multiplying-the-data-from-the-two-tables/m-p/1227969#M19986 <P>Thank you, works great.&nbsp;</P> Thu, 16 Jul 2020 11:35:20 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-multiplying-the-data-from-the-two-tables/m-p/1227969#M19986 Leski 2020-07-16T11:35:20Z