Forum Discussion

mohammedald's avatar
mohammedald
Helper I
2 years ago

I need Help With A Date Formula

Hello, Thank you so much for your time I will get right into the,   So to explain the problem so you have more context I have a dashboard that is connected through CRM online and we have deals that...
Need Help
dufoq3's avatar
dufoq3
Community Champion
2 years ago

Heve you read note below my post?

mohammedald's avatar
mohammedald
Helper I
2 years ago

sorry I just saw it, but it seems that I can't get my query is this because I use Dynamics 365 online to connect the dataset?

  • mohammedald's avatar
    mohammedald
    Helper I
    2 years ago

    I think I figured it out, sorry this is my first time using Power Query so please be patient with me

    when I changed the query as you said in the note the code worked but it gave me an error in the new column rows when I clicked the error it said this 

    Expression.Error: The column 'Value' of the table wasn't found.

    Details:

        Value

     

    I think this is because the true value name in my data set is not the same the only problem is I have nearly 400 columns in the dataset do I need to identfy them all?

    • dufoq3's avatar
      dufoq3
      Community Champion
      2 years ago

      You have Value column in your sample data. Which step cause an error? ChangeType?

      • mohammedald's avatar
        mohammedald
        Helper I
        2 years ago

        Imean here

        ChangedType = Table.TransformColumnTypes(TrimmedColumnNames,{{"Value", type number}, {"Est Close Date", type date}, {"Close Date", type date}}),