Parameter is not correct type

[surendar12]

Hi ,

  I have a measure called num_users .  Attached below is an excel format of the data . I am trying to create new measure : EARLIEST(num_users) and powerBI throws an error.

Thanks in advance.

[Anonymous · Accepted solution]

HI @surendar12 ,

You can try to use following calculate column formula if it meets for your requirement:

Column =
VAR minPath =
    CALCULATE (
        MIN ( Table[Path_Sequence] ),
        FILTER (
            ALLSELECTED ( Table ),
            [Event_Date] = EARLIER ( Tabel[Event_Date] )
                && [Category] = EARLIER ( Table[Category] )
        )
    )
RETURN
    LOOKUPVALUE (
        Table[Num_users],
        Table[Event_Date], [Event_Date],
        Table[Category], [Category],
        Table[Path_Sequence], minPath,
        MIN ( Table[Num_users] )
    )

Regards,
Xiaoxin Sheng

[Tahreem24]

Can you please specify what measure logic you want to calculate?

[surendar12]

Hi @Tahreem24 

  This is what I am trying to do .