Forum Discussion

AdamHurleyEI's avatar
AdamHurleyEI
Frequent Visitor
2 years ago
Solved

Calendar Lookup Table - Dates Disappearing in 'Table View'

I built a calendar lookup table using the following MCode: let // Start and end dates for the calendar table StartDate = #date(2018, 1, 1), EndDate = DateTime.Date(DateTime.LocalNow()), // N...
Need Help
  • Wilson_'s avatar
    Wilson_
    2 years ago

    Hi Adam,

     

    The loaded date table may just not be sorted. If you search the Date column for "02 January 2018" (or search for 1/2/2018 in the below), does it pop up?

     


    ----------------------------------
    If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

     

    P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.

Wilson_'s avatar
Wilson_
Memorable Member
2 years ago

Hi Adam,

 

The loaded date table may just not be sorted. If you search the Date column for "02 January 2018" (or search for 1/2/2018 in the below), does it pop up?

 


----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

 

P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.

AdamHurleyEI's avatar
AdamHurleyEI
Frequent Visitor
2 years ago

Good spot:


Of course it was something stupid lol! Thank you

  • Wilson_'s avatar
    Wilson_
    Memorable Member
    2 years ago

    Perfect. I love it when it's user error; those are usually the quickest fixes haha