cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
semidevil Regular Visitor
Regular Visitor

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

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

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

Hi,

 

Maybe something like this

 

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

 

Format this measure as a Date.

 

Hope this helps.

2 REPLIES 2
Phil_Seamark Super Contributor
Super Contributor

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

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.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Super User
Super User

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

Hi,

 

Maybe something like this

 

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

 

Format this measure as a Date.

 

Hope this helps.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 115 members 1,705 guests
Please welcome our newest community members: