Forum Discussion

August1987's avatar
August1987
Regular Visitor
10 months ago
Solved

Calculating historic counts based on two date columns

Hi,   I'm new to Power BI and struggling with something I feel should be relatively easy but I can't seem to get it to work.   The table below contains some dummy data as an example and my relati...
  • PhilipTreacy's avatar
    PhilipTreacy
    10 months ago

    Hi August1987 

     

    This seems to be a separate issue to the original question i.e. you now mention a y-axis so there's a chart visual involved.

     

    Have you tried my suggestion and checked my example PBIX file?

     

    It's very hard to diagnose an issue when you don't supply the full dataset, or your PBIX file, or even some screenshots.  Please supply your PBIX file if you can, it'll make things much easier to help you.

     

    Phil

August1987's avatar
August1987
Regular Visitor
10 months ago

Thank you for your detailed response, I appreciate it so much.

 

When I've created the measure using my data I'm having a couple of issues. It returns a correct count of outstanding cases (currently 7765); however, when I add another field to the y-axis it shows 7765 for every item within that field. Also, when I add a slicer using the WC date and select a week, it returns a blank result.

 

Any ideas?

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
10 months ago

Hi August1987 

 

This seems to be a separate issue to the original question i.e. you now mention a y-axis so there's a chart visual involved.

 

Have you tried my suggestion and checked my example PBIX file?

 

It's very hard to diagnose an issue when you don't supply the full dataset, or your PBIX file, or even some screenshots.  Please supply your PBIX file if you can, it'll make things much easier to help you.

 

Phil