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 !!
v-lili6-msft
Community Support
Community SupportHI, 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