Forum Discussion

Jaxon's avatar
Jaxon
Frequent Visitor
8 years ago
Solved

New Column With Date (No other dates in source)

Hoping this isn't a complete noob question....   I have a data source (Excel file) that contains data but has no DATES Column to extract from.   In the Query Editor I'd like to: 1. Add a new col...
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi Jaxon,

     

    You could create a calculated column in Data view in Power BI Desktop by Today().

     

     

    Best Regards

    Cherry

     

     

  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    Jaxon- Here is a very basic example:

     

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlSKjQUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", Int64.Type}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Refresh", each DateTime.LocalNow())
in
    #"Added Custom"
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
8 years ago

Hi Jaxon,

 

You could create a calculated column in Data view in Power BI Desktop by Today().

 

 

Best Regards

Cherry

 

 

Jaxon's avatar
Jaxon
Frequent Visitor
8 years ago

Thank-you!  I will give it a go.

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    8 years ago

    Jaxon- Here is a very basic example:

     

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlSKjQUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", Int64.Type}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Refresh", each DateTime.LocalNow())
in
    #"Added Custom"
    • Jaxon's avatar
      Jaxon
      Frequent Visitor
      8 years ago

      Thanks much! Working through it now.

       

      Sadly I have a dreaded refresh error I am trying to squash as well. (Fixed)