Forum Discussion
Solved
Need Help!! Calculating Current open claims for every month.
I can calculate new cliams and closed claims for every month current and past, however need to calculate below calculation to show current open cliams for any month in report... Current Open clia...
Try like
calculate(count(claims[id]),filter(claims,claims[Open Date]<ENDOFMONTH('Date'[Date Filer]) && claims[Close Date]>ENDOFMONTH('Date'[Date Filer]) )Where date is date table in power bi
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
amitchandak
Super User
Super UserAny thing which opens before this month-end and not closed before this month-end is open. That is what I was trying to find.
It is the same as what you are saying, just a changed way to implement.
Hi Amit, you are correct I tried and trying to put the number to report, however team want to replicate similar to the screenshot shown in attached...