dates range
1 Topic
compare data sets based on dates
Hello All, I am new to power bi and I have to build few metrics based on below sample data set. I have two give two date filters baseline and comparison and have to display a flag or highlight of the value for the column like status or Priority is changed between those dates. Suppose I select 30 Oct in base line slicer and 23 Oct in Comparison slicer a) I have to create vizulization to highlight/flag the columns that have changed. b) Count of newly added records also details c) count of deleted records and details d) count of changed records ( one of the column value is changed) and details Please help and suggest better implementation for above scenarios. runid Id Status Priority 30102023 ENG-666 Monitoring P1 30102023 ENG-111 Monitoring P1 30102023 ENG-122 Monitoring P3 30102023 ENG-333 Monitoring P3 30102023 ENG-555 Teminated P4 25102023 ENG-555 Teminated P4 25102023 ENG-111 Monitoring P1 25102023 ENG-122 Monitoring P2 25102023 ENG-333 Monitoring P3 25102023 ENG-666 Monitoring P4 20102023 ENG-111 Monitoring P1 20102023 ENG-122 Monitoring P2 20102023 ENG-333 Monitoring P3 20102023 ENG-555 Teminated P4 20102023 ENG-666 Monitoring P4 15102023 ENG-111 Monitoring P1 15102023 ENG-122 Monitoring P2 15102023 ENG-333 Monitoring P3 15102023 ENG-444 Monitoring P4 15102023 ENG-555 Monitoring P4Solved830Views0likes2Comments