how to create a dynamic date to indicate "data updated as through...[date]."

[semidevil]

I'm trying to create some sort of text box to place in my powerBI cover slide.  I want it to be a date indicator to let my audience know that the data is "Updated through....[DATE]."

[DATE] would by dynamic and change.

I can't use a "Max" date formula because I already have all of 2018 dates in my table.  I also can't use a 'previous date' logic because the data doesn't get updated on the exact same day (i,e  Sometimes, the data will be updated on April 1st, but other times, it may be updated April 8th).

I'm thinking of having my formula or measure look at one of my data columns and grab the sum of the values of the max date, but condition where the value is populated (i,e: NOT 0).  i

So in words:

refresh date = sum(column[values], date = max(date), sum(columns[values] >0).

How would I go about doing this in powerbi syntax?  Is there an easier way?

[Ashish_Mathur · Accepted solution]

Hi,

Maybe something like this

=CALCULATE(MAX(Data[Date]),FILTER(Data,SUM(Data[Value])>0))

Format this measure as a Date.

Hope this helps.

[Phil_Seamark]

HI @semidevil

What is your datasource?  If it's SQL and you are importing data, you could just import a table with a query like 'SELECT GETDATE() as LoadedDate)'  This would generate a 1 row, 1 column table with a date value you can use in a measure.  Other datasources would have a similar ability.