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"
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)