Forum Discussion

RAKESH1986's avatar
RAKESH1986
Icon for Helper II rankHelper II
3 years ago
Solved

two column subtraction, first value is not correct

Hi All, pls help me to get subtrction of two column.   i have these two column..     after this i added two index clumn and merge of these two index column      my subtraction is...
Need Help
  • Mahesh0016's avatar
    Mahesh0016
    3 years ago

    RAKESH1986 

    >> Select column [PW_EARLY_CUM.1] >> Click Right Click >> Go to replace value >> Null to 0 >> Get Your Desired Output.

    Thank You!
    **Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

  • Mahesh0016's avatar
    Mahesh0016
    3 years ago

    RAKESH1986 

    >>First Remove This Step before replase value>>#"Inserted Subtraction" = Table.AddColumn(#"Sorted Rows", "Subtraction", each [PW_EARLY_CUM] - [PW_EARLY_CUM.1] >> 

RAKESH1986's avatar
RAKESH1986
Icon for Helper II rankHelper II
3 years ago

Mahesh0016  i changed value, but still getting same result..could u check what wrong i  did?

 

 

  • Mahesh0016's avatar
    Mahesh0016
    Icon for Super User rankSuper User
    3 years ago

    RAKESH1986 

    >>First Remove This Step before replase value>>#"Inserted Subtraction" = Table.AddColumn(#"Sorted Rows", "Subtraction", each [PW_EARLY_CUM] - [PW_EARLY_CUM.1] >> 

    • RAKESH1986's avatar
      RAKESH1986
      Icon for Helper II rankHelper II
      3 years ago

      Mahesh0016  its working fine now..many thanks for help.