Forum Discussion
HELP DAX URGENT
Hi,
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.
Super UserHi,
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.
I Excusme again. Your statement is correct and the distribution you propose is true.
This is the Expected Result
Year1. Changed Department 2. Nivel Changed 3. Joined the Company 4. Have Left 2013 0 0 0 0 2014 2 2 1 0 2015 3 2 0 1 2016 3 3 1 1 Total 8 7 2 2