Forum Discussion
DAX text calculation
Can anyone help me figure out the DAX formula to get the last column of this table (C Desc) ?
| Account | T # | T Date | C Date | T Desc =Related(relationship between this table's T# field and T# Description table) | C Desc |
| 1 | 3777 | 1/1/2017 | 3/5/2017 | Charge | Adj |
| 1 | 7016 | 3/5/2017 | 3/5/2017 | Adj | Adj |
| 1 | 5716 | 6/9/2017 | 3/5/2017 | Cash | Adj |
| 2 | 8628 | 3/12/2017 | 9/2/2017 | Charge | Cash |
| 2 | 2855 | 9/2/2017 | 9/2/2017 | Cash | Cash |
| 2 | 9561 | 10/16/2017 | 9/2/2017 | Adj | Cash |
| 2 | 7026 | 11/22/2017 | 9/2/2017 | WO | Cash |
1 Reply
If you were to do it yourself, what would you do?
i.e. I totally don't understand how your last column has any logical relation to the rest. If you explain that a little more, we might be able to help.
