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?
Please attach the workbook/ data with expected output.
As the formula doesn't look familiar from Tableau.
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.
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 like-for-like 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.