No date column data

[Manasi25]

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.

[Anonymous]

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]

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.

[FarhanJeelani · Accepted solution]

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.

[Manasi25]

Hi, but if I refresh the data / open my pbx file, it will again show the current date into a custom date col, how can I show then it ?

[mdaatifraza5556]

Hi @Manasi25 

Please try the below steps:

In Power Query create custome column using ->
Date.From(DateTime.LocalNow())

And then with the help of DAX try to displace the data which is equal to today date using
TODAY() in your DAX  (While creating a measure).

[Manasi25]

I created custom column and its showing local system date, also created Today DAX, how it will be implemented on my data?

[AkhilGrandhi1]

Hi
You can create a measure like Current Date = TODAY() and use this.

[Deku]

Add a new table in power query with a single column and row calculated with DateTime.LocalNow(). This will get updated with every refresh, and you can show on your report page