HELP DAX URGENT

[Ashish_Mathur · Accepted solution]

Hi,

On the data that you have shared, show the exact expected result in a simple Table format.

[jtobon88]

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.

[jtobon88]

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.

[jtobon88]

I Excusme again. Your statement is correct and the distribution you propose is true.

This is the Expected Result

Year	1. 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

[Ashish_Mathur]

Hi,

You may download my PBI file from here.  I have not understood the second question so have left that.

Hope this helps.

[jtobon88]

thanks friend 🙂

[Ashish_Mathur]

You are welcome.