Forum Discussion

JennyMilf's avatar
JennyMilf
Icon for Helper I rankHelper I
3 years ago

Measure - display true/false 3 months consecutively

Hi,

I got data like the photo below,

How can I create new measures that can display true/false 3 months consecutively base on ISDN and Activate_date ? Thank you!

 

 

 

Need Help

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    3 years ago

    Hi,

    I am sure if I understood your question correctly, but please check the below picture and the attached pbix file.

     

     

    Expected result measure: =
VAR _nextmonthenddate =
    EOMONTH ( MAX ( Data[Activate date] ), 1 )
RETURN
    IF (
        HASONEVALUE ( Data[ISDN] ),
        IF ( MAX ( Data[Expire date] ) > _nextmonthenddate, "True", "False" )
    )

     

  • JennyMilf's avatar
    JennyMilf
    Icon for Helper I rankHelper I
    3 years ago

    Thank you for your response, but it's not my mean

    Ex:

    ISDN = A

    Activate_date of 'A' is: 11/01/2022 and 12/01/2022 and 01/01/2023

    Result of A: True