Forum Discussion

JulietZhu's avatar
JulietZhu
Helper IV
7 years ago
Solved

Error when DATEDIFF use as filter

I have claim lag calucaited based on datediff between enc_date and final_bill_date.  After  I calculate claim lag, I need count total records for each claim lag range. Below is screenshot for 2 to 7 ...
Need Help
  • tarunsingla's avatar
    tarunsingla
    7 years ago

    Minor fix in the measure:

     

    ClaimLag_2-7Days = CALCULATE(COUNT(EncounterCount[ClaimLag]),filter(EncounterCount, EncounterCount[ClaimLag]>=1 && EncounterCount[ClaimLag]<=7))

     

    You need to use &&.

     

    Regards,

    Tarun

tarunsingla's avatar
tarunsingla
Solution Sage
7 years ago

Minor fix in the measure:

 

ClaimLag_2-7Days = CALCULATE(COUNT(EncounterCount[ClaimLag]),filter(EncounterCount, EncounterCount[ClaimLag]>=1 && EncounterCount[ClaimLag]<=7))

 

You need to use &&.

 

Regards,

Tarun