Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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.
Hi,
Maybe something like this
=CALCULATE(MAX(Data[Date]),FILTER(Data,SUM(Data[Value])>0))
Format this measure as a Date.
Hope this helps.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |