Forum Discussion

Benjosh's avatar
Benjosh
Icon for Helper I rankHelper I
5 years ago
Solved

DAX Columns for the following

 

I want to create 2 column for the following calculation. looking for DAX for these formulas 

"Column 1" Balance = (Arr_demand + Current) - (Arr_Collection + Current)
"Column 2" Arrear analysis = Balance/Current Demand

Details will be shared on reply 

Need Help
Tips and Tricks
  • Fowmy's avatar
    Fowmy
    5 years ago

    Benjosh 

    If you can provide sample data and column headings then it will be clear for us to understand.


  • Benjosh's avatar
    Benjosh
    5 years ago

    Fowmy  I Figured out the answer from Transform Data --> create Column --> Custom Column 

    Thank You

2 Replies

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    5 years ago

    Benjosh 

    If you can provide sample data and column headings then it will be clear for us to understand.


    • Benjosh's avatar
      Benjosh
      Icon for Helper I rankHelper I
      5 years ago

      Fowmy  I Figured out the answer from Transform Data --> create Column --> Custom Column 

      Thank You