Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    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.

     



Fowmy's avatar
Fowmy
Super User
5 years ago

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.

 



  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Fowmy,

    Many thanks for taking the time to read and respond to my post. Much appreciated!

    I have reviewed the pbix file you kindly created and attached for me, and applied it to my dashboard.

    I am still unable to split out the calculations to show in separate visuals though.

    Please see this snip of my dashboard with what I'm trying to display.

    Am I missing something obvious?