Data Detection from a Table (daily)

[cyruschan]

My main purpose is to ensure that we are getting new data each day. I have a PowerBI dashboard that has a table with the following columns: Date, Exposure, Capacity. I would like to add a new measure or quick measure that shows the Difference in Exposure between each day.

How would you suggest this be done using New Measure or another method? I do not have access to edit queries or altering the data set.

With that new measure, I would like to then line-graph it to show changes each day and not at any point have that line show zero/no change.

Please advise.

Thank you in advance!

 

[severynm]

If your data is continuous (i.e. does not skip a day), you can use something as simple as

Measure = CALCULATE(SUM(Table2[Result]),DATEADD(Table2[Date],-1,DAY))

Otherwise, you might try alternatives as proposed here.

 

[cyruschan]

Question:

Is there a tracker I can add (measure) to know whether I am getting updated data because there can be days of zero exposure if no activity is on those days?

Please advise. I added a difference measure to my table and will try what you suggested.

 

[severynm]

Is there a tracker I can add (measure) to know whether I am getting updated data because there can be days of zero exposure if no activity is on those days?

Probably not, at least that I know of. You can add a measure to determine the time that the data was last refreshed, but that does not guarantee anything as you can refresh without adding any new data (also you might be out of luck if you cannot access the queries at all, as this method requires adding a new simple one-lined query). You could also pull out the most recent date/time to a card, but you end up with the same issue. You might have to intuit this based on the most recent data point vs. how frequently you know your data source publishes the data. Someone else at Microsoft Power BI Community might know better, however.