M Script Error

[Anonymous]

Hi Experts

I cannot see where the error is in the following M Script as a custom column in Power Query

#"Add Custom" = Table.AddColumn(Source, "Status", each 
        if [#"Dataset"] =  "" and  Date.Month([Date]) = 4 then "A" else [#"Dataset"] 

[Anonymous]

Hi, @Anonymous 
Thanks for nilendraFabric's reply. It doesn't look like there's anything wrong with your code, you can try his suggestion and if it still doesn't work, you can share the pbix file with no sensitive data for testing.

Best Regards,
Yang
Community Support Team

[nilendraFabric]

HI @Anonymous 

Give this a try 

#"Add Custom" = Table.AddColumn(Source, "Status", each
if [Dataset] = "" and Date.Month([Date]) = 4 then "A" else [Dataset])

[nilendraFabric]

@Anonymous Did it worked?

[Anonymous]

Still updating file. is a big PBIX