Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dax Query with date variables

Trying to insert some rows into my records without adding a new source. Mostly got it working but it would be nice if there was a predefined date variable I could use to get the current year, month, ...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    You can use this to insert 01-01-2022

    = Table.InsertRows(#"Renamed Columns", 0,{[Date = Date.ToText(Date.StartOfYear(Date.From(DateTime.FixedLocalNow())),"MM/dd/yyyy") , Value = 0, Name= "xraphael"]})

     If you want to use the first date of month, then replace Date.StartOfYear with Date.StartOfMonth.

    If you want current date, then remove Date.StartOfYear.

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

You can use this to insert 01-01-2022

= Table.InsertRows(#"Renamed Columns", 0,{[Date = Date.ToText(Date.StartOfYear(Date.From(DateTime.FixedLocalNow())),"MM/dd/yyyy") , Value = 0, Name= "xraphael"]})

 If you want to use the first date of month, then replace Date.StartOfYear with Date.StartOfMonth.

If you want current date, then remove Date.StartOfYear.