Forum Discussion

Manasi25's avatar
Manasi25
Helper II
1 year ago
Solved

No date column data

Hello team I have data, that have no Date/Time column and I want to present the latest updated data. Data is updated daily.How can I represent data with current dates where i have no date column....
Tips and Tricks
  • FarhanJeelani's avatar
    FarhanJeelani
    1 year ago

    Hi Manasi25 ,

    Since your data lacks a Date/Time column but is updated daily, you can follow these steps to associate your data with the current date:

     

    Solution Approach
    Add a Date Column in Power Query:

    Open Power Query.
    Add a Custom Column with:
    powerquery

    Date.From(DateTime.LocalNow())

    This assigns today's date to every row in your dataset.


    Use a Measure to Filter Today’s Data:

    In DAX, create a measure:

    TodayDataFlag = IF( MAX( YourTable[CustomDate] ) = TODAY(), 1, 0 )

    Use this measure as a filter in visuals (= 1) to display only the latest updated data.

     

    Alternative: Store Last Refresh Date in a Separate Table

    Create a new table:
    DAX

    LastRefreshDate = ADDCOLUMNS( CALENDAR(TODAY(), TODAY()), "Last Refresh", TODAY() )

    Join this table with your data and use it as a reference for filtering.


    This approach ensures that your report dynamically updates to show only the latest available data, even without a native Date/Time column in your source data.

     

    Please mark this post as solution if it helps you. Appreciate Kudos.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Manasi25,

Thanks for reaching out to the Microsoft fabric community forum.

It looks like you are looking for a way to get current date data without a date column. As FarhanJeelani, mdaatifraza5556, AkhilGrandhi1 and Deku all responded to your query, can you please confirm if your issue has been resolved or not. Also were you able to go through their responses.

 

I would also take a moment to thank FarhanJeelani, mdaatifraza5556, AkhilGrandhi1 and Deku, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference

 

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.
Community Support Team

 

If this post helps then please mark it as a solution, so that other members find it more quickly.

Thank you.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Manasi25,

As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.

If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.


If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.