Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
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.
User | Count |
---|---|
99 | |
86 | |
78 | |
75 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |