Forum Discussion

Vamshi_R's avatar
Vamshi_R
Frequent Visitor
6 years ago
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...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    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.

Vamshi_R's avatar
Vamshi_R
Frequent Visitor
6 years ago

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

If open claim no is correct. This how you have to deal with open and close.

Make sure you have a date dimensions table. Marked as Date Table in Power BI Model.

Join it both open and close date. One or both can be inactive joins. As per your current join.

Refer to the article below on how to use userelation to shift date.

 

https://community.powerbi.com/t5/Desktop/DATE-RANGE-SLICERS-TO-COMPARE-NETSALES-OF-A-DATE-RANGE/td-p/42251

 

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.

  • Vamshi_R's avatar
    Vamshi_R
    Frequent Visitor
    6 years ago

    Thank you Amit, will check as you suggested.