fill down

[sportive92003]

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!

[dharmendars007 · Accepted solution]

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

LinkedIN