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 UserTry 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.