Forum Discussion
Dax formulas work and no work
Hi! I have a weird problem with my data and dax formulas. I have an excel worksheet where everymonth I paste the data from the past month. I've load this excel to my power bi, create some DAX for...
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.