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.
Thanks. That is the Tachometer visual (I don't think it's custom?). I have four of them in a row.
I have dragged the Expiry Bracket field, however that is just a blank text field?
Fowmy
Super User
Super UserAnonymous
You can set the bracket as follows in the filters pane