Forum Discussion
Dax formulas work and no work
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