Forum Discussion

preetha_127's avatar
preetha_127
Frequent Visitor
6 years ago
Solved

undefined

Hi Team,

I have same multiple invoice id with different invoice amount.I want sum those invoice amount against one invoice.

 

Dashboards
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    6 years ago

    Hi preetha_127, 

     

    You can create a calculated column and measure like below: 

     

    InvoiceNew = LEFT('Table'[Invoice],3)
     
    TotalByInvoice = CALCULATE(SUM('Table'[Invoice amount]),FILTER('Table','Table'[InvoiceNew]=MAX('Table'[InvoiceNew])))
     

     

     

    Best Regards,
    Qiuyun Yu

3 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    6 years ago

    Hi preetha_127, 

     

    You can create a calculated column and measure like below: 

     

    InvoiceNew = LEFT('Table'[Invoice],3)
     
    TotalByInvoice = CALCULATE(SUM('Table'[Invoice amount]),FILTER('Table','Table'[InvoiceNew]=MAX('Table'[InvoiceNew])))
     

     

     

    Best Regards,
    Qiuyun Yu

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    preetha_127 , Same solution as v-qiuyu-msft , But in case you can have more than 3 digit

    Try like

    New Column =

    var _len = search("(",[invoice] ,,0)

    return

    if(_len =0 ,[Invoice],left([Invoice],_len-1)

  • preetha_127's avatar
    preetha_127
    Frequent Visitor
    6 years ago

    Hi team,

    I have multiple report,also i have summary of all the report.If i click one report in summary page ,it will navigate particular report.Help me..

     

     

     

     

    Thanks & Regards,

    Preetha