Forum Discussion
surendar12
6 years agoRegular Visitor
Parameter is not correct type
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. Th...
- Anonymous6 years ago
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
6 years agoSuper User
Can you please specify what measure logic you want to calculate?
surendar12
6 years agoRegular Visitor