Can't adding the blank field with values or status

[francisjohn83]

Hello Colleagues,

I'm currently working on one of the project module, In the project I would like to show the MMM-YY in column and companies in rows. The logic is simple, If companies(companies table) are matching with upload accounts table(Companies name) then the status should be "done" or "pending". Logic is applying for Done actually and it's not turn up for blank field with "pending" status.

IF(

    ISBLANK('UploadAccounts'[Month]),

    "Pending",

    IF(

        UploadAccounts[CompanyShortName] = RELATED(Companies[shortName]),

        "Done",

        "Pending"

    )

)

Do the needul on the above request !

[Anil_kapkoti]

First you need to check your data model, 
Make Sure the Relationship should define correctly.
The related function is work if you are flowing the data from dimension to fact table or one to many side, Not many to one side.
For more calarity you can share a dummy dataset.

[francisjohn83]

Thanks Anil, I'm sharing the sreenshot for your reference.