Forum Discussion
Dax formulas work and no work
I just understand the difference why in one works and in the other one don't.
I have the data of all the employees (including managers and no managers) with columns such as the quantity of recognitions they gave and the name of his manager.
I create another column beside the managers name with the "Estado/Status" (first formula) and how many recognitions they gave (the second i used). Which other formula would you recommend?
thanks!!
Anonymous - The calculation depends on what you're trying to achieve. Could you provide some sample data and expected result. Especially important is what do you want to happen when there is more than one value row with the same employee / manager?
I think i understandthe problem. When there are 2 months in the power bi, there are 2 different results, thats why figures ERROR. When I only leave one month, this doens´t happen.
Is there a way I can include in the formulas I already have a filter that is sincronized with my slicer Month?
thanks a lot again Anonymous !!
Anonymous - If you want to continue to use LOOKUPVALUE, you could add a third filter for the month.
However, it seems like you already have the information you need - I am not sure whether you need this calculation at all. For instance, if you are using a table or matrix, simply use the existing column.
v-lili6-msftCommunity Support
HI, Anonymous
The best way is that add a year-month column (the next month) when you load the next month data.
Then add a conditional that group year-month.
Best Regards,
Lin