Forum Discussion
Reporting different counts on a date column
Hi there, I wonder if anyone can help? I have a date column in a table called 'Expires' and I want to show a count of any dates that fall into the following ranges: Any dates that have already p...
Anonymous
When you use CALCULATE in a column multiple times, there is context transition, and circular dependency occurs.
I think the best way to solve your problem is using a disconnected table as follows. Please refer to the attached PBIX file. I created a dummy date table, you can replace it with your expires column.
Fantastic! Thanks so much for your help with this.
I really appreciate it.
Anonymous
You are most welcome!