Forum Discussion

learner03's avatar
learner03
Icon for Post Partisan rankPost Partisan
5 years ago
Solved

Today's date not refreshing in Power Bi Service

I created a dashboard yesterday and published in Power BI serice. I scheduled refresh but when it refreshed today morning, the calendar table didn't refreshed and the measures where I was using "TODAY()"are showing BLANK. How can I correct this? It seems that the calander table is not refreshing. In below picture, it is showing 6 july, but it should show 7th july after refresh.

 

 

  • aj1973's avatar
    aj1973
    5 years ago

    Ok then the TODAY() in your formula is good. did you replace 1 by 2 or 3 or... in the M code?

    let
    Source = List.Dates(StartDate, Length+2, #duration(1, 0, 0, 0)),

    ...

     

    doing so, you should be good.

16 Replies

    • learner03's avatar
      learner03
      Icon for Post Partisan rankPost Partisan

      aj1973 Using the below code-

       

      let
      Source = List.Dates(StartDate, Length+1, #duration(1, 0, 0, 0)),
      #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
      #"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "Date"}}),
      #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"Date", type date}}),
      StartDate = #date(2021, 1, 1),
      Today = DateTime.Date(DateTime.LocalNow()),
      Length = Duration.Days(Today - StartDate),
      Custom1 = #"Changed Type",
      #"Inserted Year" = Table.AddColumn(Custom1, "Fin Year", each Date.Year([Date]+#duration(184,0,0,0)), Int64.Type),
      #"Inserted Month Name" = Table.AddColumn(#"Inserted Year", "Month Name", each Date.MonthName([Date]), type text),
      #"Inserted Day Name" = Table.AddColumn(#"Inserted Month Name", "Day Name", each Date.DayOfWeekName([Date]), type text),
      #"Inserted Month" = Table.AddColumn(#"Inserted Day Name", "Fin Month", each if Date.Month([Date]) >=7 then Date.Month([Date])-6 else Date.Month([Date])+6 , Int64.Type),
      #"Inserted Day of Week" = Table.AddColumn(#"Inserted Month", "Day of Week", each Date.DayOfWeek(([Date]), Day.Sunday), Int64.Type),
      #"Inserted First Characters" = Table.AddColumn(#"Inserted Day of Week", "MMM", each Text.Start([Month Name], 3), type text),
      #"Inserted First Characters1" = Table.AddColumn(#"Inserted First Characters", "DDD", each Text.Start([Day Name], 3), type text),
      #"Reordered Columns" = Table.ReorderColumns(#"Inserted First Characters1",{"Date", "Fin Year", "Month Name", "MMM", "Fin Month", "Day Name", "DDD", "Day of Week"}),
      #"Added Custom" = Table.AddColumn(#"Reordered Columns", "FYMM", each ([Fin Year]-2000)*100 + [Fin Month]),
      #"Changed Type1" = Table.TransformColumnTypes(#"Added Custom",{{"FYMM", Int64.Type}}),
      #"Added Custom1" = Table.AddColumn(#"Changed Type1", "MonthID", each (Date.Year([Date]) - Date.Year(StartDate))*12 + Date.Month([Date])),
      #"Changed Type2" = Table.TransformColumnTypes(#"Added Custom1",{{"MonthID", Int64.Type}})
      in
      #"Changed Type2"

       

      Also I don't see the calendar table under Data source credentials (Don't know if I am suppose to see this underthis or not)-

      This is the first dashboard I have published and I am new to this.

      • aj1973's avatar
        aj1973
        Icon for Community Champion rankCommunity Champion

        It's all good

        where is your location?, check the browser you need to change the date/time of your browser

  • prudvit's avatar
    prudvit
    Frequent Visitor

    Simple and Temporary Fix:
    add a Filter and say in the the next x days in relative Date.