Forum Discussion
fill 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
1 Reply
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