
1. Re: DAX Formula to Tableau
Sasha Hanna Sep 5, 2018 6:34 AM (in response to julian.ramirez.0)Hola Julian,
Have you copy pasted this formula from SQL or another platform?
It looks like the syntax is somewhat different to Tableau. Could you explain what the formula is supposed to do and attach a sample data set?
Cheers,
Sasha

2. Re: DAX Formula to Tableau
meenu choudhary Sep 5, 2018 6:51 AM (in response to julian.ramirez.0)HI Julian,
Please attach the workbook/ data with expected output.
As the formula doesn't look familiar from Tableau.

3. Re: DAX Formula to Tableau
julian.ramirez.0 Sep 5, 2018 7:10 AM (in response to julian.ramirez.0)Thanks for your answer.
The copied code is from Power BI, specifically from DAX which is used to do advanced calculations there. What I want to do is something like this:
It caculates the Hired/Fired employees against previous month. Everything that i'm expecting is in the link provided.
Regards,Julián

4. Re: DAX Formula to Tableau
Okechukwu Ossai Sep 5, 2018 6:33 PM (in response to julian.ramirez.0)Hi Julian,
You can use LOD expressions to recreate Power BI's CALCULATE function which returns a scalar.
CALCULATETABLE, on the other hand returns a virtual table which can be filtered, so there is no likeforlike equivalent in Tableau. However, Tableau is versatile and you can rewrite that formula in several ways. I have provided a solution in the original thread. Your data needs some restructuring and possibly data aggregation to reduce extract size.
Ossai