Forum Discussion
Issue with Filtering out Certain Data from a Date Table Using DAX
Hello Anonymous , thanks so much for your reply!
Yes, I have a separate table for Dates. What do you mean that I have to disconnect the 2 tables (is this in reference to their relation for data modelling)?
Also, should add this just as a measure in one of the tables, or is this something to add to the table formula I've provided in my initial post?
Thanks!
Kindly following up on my previous question. If you can let me would be just appreciated. Thanks!
Hi meredink91 ,
Yes, if you use dates for filtering, you need to disconnect the join between the two tables.
Try my syntax and if that doesn't help you solve the problem. I would appreciate it if you could provide me with the pbix file or sample data.
Please remember to delete sensitive data and do not log into your account in Power BI Desktop when uploading pbix files.
If you have any other questions, please feel free to contact me.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!Thanks Anonymous - I did try to the syntax and still not working. How do I send you a sample pbix file through here?