Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |