Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi everyone,
Learning PBI currently, and need help. From the sample table below, I have data that I update frequently leaving a trail of historical records. I have one of my analysis set up, however, it isn't correctly showing the right answer because of how the dates work. The easiest solution I can think of is to make so it only analyzes the most recent data everytime and visually show it on the log. The most recent data currently is September 13. Currently, the PBI is analyzing and visually showing every data & date. I do still want to be able to filter through the historical log.
For example, visually the most recent data is always displayed and analyzed. But I still want to be able to keep the historical data hidden but still visible only when I filter (This part I'm sure I can figure out by creating a page navigation)
Solved! Go to Solution.
Hi,
Not sure if I could understand.
But if there is any field that it is indicated the historical/current data you could put it in the filter pane for your visual/page/report.
Or if each day the data is archived, you could create the column/measure in your table and put it as max(date) or today() and then set the particular column/measure in your filter pane
If you are looking for others would you please say a sample as a current and expected result here ?
thanks for Kudos
Hi,
Not sure if I could understand.
But if there is any field that it is indicated the historical/current data you could put it in the filter pane for your visual/page/report.
Or if each day the data is archived, you could create the column/measure in your table and put it as max(date) or today() and then set the particular column/measure in your filter pane
If you are looking for others would you please say a sample as a current and expected result here ?
thanks for Kudos