Forum Discussion
sportive92003
Helper II
Helper IIfill down
Hello, How can I put the same name of vendor when the no_client NUM still have a name of vendor? If the no_client NUM don't have any client name, then let blank. Thank!
Hello sportive92003 ,
Please try this DAX to create the calculated column..
Vendor =
IF(
NOT(ISBLANK(Table[nom_client])),
CALCULATE(
MAX(Table[Vendeur]),
FILTER(
Table,
Table[no_client NUM] = EARLIER(Table[no_client NUM]))),
BLANK())If you find this helpful , please mark it as solution and Your Kudos are much appreciated!
Thank You
Dharmendar S
dharmendars007
Memorable Member
Memorable MemberHello sportive92003 ,
Please try this DAX to create the calculated column..
Vendor =
IF(
NOT(ISBLANK(Table[nom_client])),
CALCULATE(
MAX(Table[Vendeur]),
FILTER(
Table,
Table[no_client NUM] = EARLIER(Table[no_client NUM]))),
BLANK())
If you find this helpful , please mark it as solution and Your Kudos are much appreciated!
Thank You
Dharmendar S