Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

missing fiscal quarter

hi all... I have this missing quarter in my table thus having the following error msg. But i am not sure how i should correct it. the same set of data was working fine few months ago until 2020 data...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , This is one

     

    #"Invoked FunctionSource" = Source(#date(#"Start Year", 1, 1), Duration.Days(DateTime.Date(DateTime.FixedLocalNow()) - #date(#"Start Year",1,1)), #duration(1, 0, 1, 0)),

    That should go max of sales or like Date.FromText("2020-12-31")

ToddChitt's avatar
ToddChitt
Icon for Super User rankSuper User
5 years ago

Date functions like SAMEPERIODLASTYEAR work best when there is a CONTIGUOUS list of dates. That can't happen if you reference some Date type column in your FACT table. You should create a Date dimension table and join it to the fact table, then when you use the function, it looks like this: SAMEPERIODLASTYEAR('Dates Table'[Date Field])

 

Hope that helps.