cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
umangsrivastava Frequent Visitor
Frequent Visitor

Create a measure with column of many measures done on different columns from different tables

 

 

A measure that calculate 

 

if A.currency = B.currency then(these conditions may be different)

mymeasure = A.measure(sum of price) * B.Exchangerate

 

How i can achieve this please help!

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Create a measure with column of many measures done on different columns from different tables

Hi @umangsrivastava ,

Please try to use below formula, I create a summary variable table to stored total sales and correspond exchange rate for calculate:

Result =
VAR summary =
    SUMMARIZE (
        T1,
        [Currency],
        "Total Sales", SUM ( T1[Sales value] ),
        "Ex rate", LOOKUPVALUE ( T2[Exchange Rate], T2[Currency], [Currency] )
    )
RETURN
    SUMX ( summary, [Total Sales] * [Ex rate] )

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
3 REPLIES 3
Community Support Team
Community Support Team

Re: Create a measure with column of many measures done on different columns from different tables

HI @umangsrivastava ,

I think it will be help if you share table structures and sample data for test and coding formula .

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
umangsrivastava Frequent Visitor
Frequent Visitor

Re: Create a measure with column of many measures done on different columns from different tables

hi thanks for your reply please find below table structure with sample data

 

Table 1
CurrencyDateSales value New Measure
AED01-01-2019100 Sum of sales value currency wise per month
AED02-01-2019110  
AUD02-01-2019120  
     

 

Table 2 
CurrencyExchange Rate
AED0.21
AUD0.71

 

i need

my measure = New Measure*Exchangerate (currency wise grouped)

 

i.e for AED 

new measure = 110 +100

mymeasure = new measure * Exchangerate(0.21)

Community Support Team
Community Support Team

Re: Create a measure with column of many measures done on different columns from different tables

Hi @umangsrivastava ,

Please try to use below formula, I create a summary variable table to stored total sales and correspond exchange rate for calculate:

Result =
VAR summary =
    SUMMARIZE (
        T1,
        [Currency],
        "Total Sales", SUM ( T1[Sales value] ),
        "Ex rate", LOOKUPVALUE ( T2[Exchange Rate], T2[Currency], [Currency] )
    )
RETURN
    SUMX ( summary, [Total Sales] * [Ex rate] )

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |