Forum Discussion
katieandemil
6 years agoFrequent Visitor
Why do I get this DAX error
Hi, I would like to understand why I get an error when I try to filter date field from reporting date dimension using my fact table field Due Date. This variable SequenceResultWithError returns this...
amitchandak
6 years agoSuper User
you need to change
var DueDate = allselcetd(Forecast[Due Date])or
var DueDate = maxx(Forecast,Forecast[Due Date])
As per need.
Using that column is passing all values from another table.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601