Forum Discussion

Chipsahoy1's avatar
Chipsahoy1
Helper I
1 year ago
Solved

Changing Values Based on 2 Different Columns

Hi All,   Hoping you all could help me.  I am trying to create a new column (Invoiced Price) in my data table that changes the value from the total cost column based on the invoice # and a keyword ...
Need Help
  • Shravan133's avatar
    Shravan133
    1 year ago

    maybe create a calculated column :

    Invoiced Price =
    VAR CurrentInvoice = 'Table'[Invoice #]
    VAR HasPackage =
    CALCULATE(
    COUNTROWS('Table'),
    ALLEXCEPT('Table', 'Table'[Invoice #]),
    SEARCH("package", 'Table'[Product Description], 1, 0) > 0
    )
    VAR IsPackageRow = SEARCH("package", 'Table'[Product Description], 1, 0) > 0

    RETURN
    IF(
    HasPackage > 0,
    IF(IsPackageRow, 'Table'[Total Cost], 0),
    'Table'[Total Cost]
    )

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Chipsahoy1,

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

 

Regards,
Vinay Pabbu

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi @Chipsahoy1,

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

 

Regards,
Vinay Pabbu