DAX help for If and Datediff combined

[JulietZhu]

If the number calculated from datediff <0, then use blank, otherwise use datediff. The DAX I wrote below gives me error. 

What is the right DAX? Thanks

[OwenAuger · Accepted solution]

@JulietZhu 

A DAX expression is not allowed to return values of different types under different conditions.

Replace the " " with BLANK () to make your existing expression work.

Also, a slightly more concise way of achieving the same result is:

ClaimLag>0 =
MAX (
    BLANK (),
    DATEDIFF (
        EnounterCount[enc_Date_date],
        EncounterCounr[Final_Bill_date_date],
        DAY
    )
)

This returns the DATEDIFF result if it is 0 or more since BLANK() is treated as zero, and MAX ( BLANK(), 0 ) returns 0, and otherwise returns BLANK ().

Regards,

Owen

[JulietZhu]

@OwenAuger ,it works. Thanks for your reply. 

[JulietZhu]

@OwenAuger, after I calculate claim lag, I need count total records for each claim lag range. Below is screenshot

for 2 to 7 days. Would you please let me know where I need correct DAX? Thanks

Please let me know if you need dummy data. Thanks