Forum Discussion
Resolver IDay to Day Comparison
Hello,
I am not sure if this is possible in Power BI. I have a csv file that runs on a daily basis. The first column is Date/Time and the second column is portfolio code. The report contains about 75 columns. If a value is changed from one day to the next, i just want those changes to appear. For example, for portfolio code 55555, a column titled Limit Amount contains a value of 100,000 on 2.8.2022 report but then on the 2.9.2022 report the value is changed to 200,000. Can Power BI show just the cells that are changed from day to day?
3 Replies
- amitchandak
Super User
gmasta1129 , If dates are different columns then I would suggest to unpivot them
If date has timestamp, Create a new column = datevalue([Datetime])
for DAy on Day refer
Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c3243d1f9 
gmasta1129All the columns are in the same order day to day. I have a date time column which is the first column of the report I just want to know if power bi can show only changes (if any are made) from one day to the next. And if so how is that done? I dont want to see the entire report of 75 columns, only changes made.
v-xiaotangCommunity Support
Hi gmasta1129
You can go to PQ Editor and add a new column, which uses an if statement to determine whether the value has changed according to the date. This allows you to add a new column to the model without changing the data source.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
