Forum Discussion
HELP DAX URGENT
Hi,
On the data that you have shared, show the exact expected result in a simple Table format.
Super UserHi,
On the data that you have shared, show the exact expected result in a simple Table format.
This the expected result
| YEAR | DEPARTAMENT changed | promoted | joined the company | have left |
| 2013 | 0 | 0 | 0 | 0 |
| 2014 | 2 | 2 | 1 | 0 |
| 2015 | 1 | 2 | 0 | 1 |
| 2016 | 2 | 3 | 1 | 1 |
Example:
* Department Changed:
ID 1 ID 1 was changed from department A to department B in 2014.
- Ashish_Mathur
Hi,
Your and my answers for Department changed do not match for 2015 and 2016. For 2015 and 2016, the answer should be 3 (see screenshot below) and revise the answers that you have shared.
Excuse me, if you're right with your answer. How can I recreate this dax? you share that .PBIX
Thanks
- Ashish_Mathur
You have not answered my question. Am I correct in the statement that I made in the previous post? Also, review your expected answers and make corrections. Share the updated expected result table. I'd like to share the PBI file only after I have computed all measures.