No date column data

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.