Forum Discussion

Jeffery24's avatar
Jeffery24
Icon for Helper I rankHelper I
7 years ago
Solved

Use parameter value as custom column

  Hi, How would I pass a parameter as just a number in an added column. For example if parameter is set at 0.85 How would I add the value of the parameter as column value?   = Table.Add...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Jeffery24

     

    = Table.AddColumn(#"Added Custom1", "Vendor KPI", each #"Vendor KPI")
Mr_Glister's avatar
Mr_Glister
Icon for Advocate II rankAdvocate II
6 years ago

Thanks for providing the answer! I've been looking for a while but can't quite find a good explanation what the hashtag (#) does in M language. Is it specifically for calling a parameter?

Jeffery24's avatar
Jeffery24
Icon for Helper I rankHelper I
6 years ago

Mr_Glister, Sorry for late reply. Am no expert but I think it is using the # to call a variable with a space in the name.