Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
94 | |
79 | |
74 | |
63 | |
59 |
User | Count |
---|---|
110 | |
101 | |
84 | |
64 | |
62 |