@v-rongtiep-msft
1 Topic
Capture Category as per selected date dynamically
Dear Team, Belwo is my source data. we have two slicers, Date1 SLicer adn Date 2 Slicer. When i select Date 1 Slicer then Category of that particular ID and RO Value should be captured. When i select Date 2 Slicer then Category of that particular ID and RO Value should be captured. Delta should be processded R&O value at Date2 - R&O value at Date1 INPUT DATE ID Category R&O Value 1-Nov-23 RO12 BLUE 100 1-Nov-23 RO13 CLOSED 0 1-Nov-23 RO14 BLUE 200 1-Nov-23 RO15 IMPLEMENTED 0 2-Nov-23 RO12 BLUE 200 2-Nov-23 RO13 BLUE 100 2-Nov-23 RO14 BLUE 200 2-Nov-23 RO15 BLUE 300 3-Nov-23 RO12 CLOSED 0 3-Nov-23 RO13 BLUE 0 3-Nov-23 RO14 IMPLEMENTED 300 3-Nov-23 RO15 BLUE 400 3-Nov-23 RO16 BLUE 350 SLICER Date1 -SLICER Date2-SLICER 1-Nov-23 3-Nov-23 OUTPUT ID Category at Date1 Category at Date2 R&O value at Date1 R&O value at Date2 Delta RO12 BLUE CLOSED 100 0 -100 RO13 CLOSED BLUE 0 0 0 RO14 BLUE IMPLEMENTED 200 300 100 RO15 IMPLEMENTED BLUE 0 400 400 RO16 BLUE 0 350 350 Regards Reddy.Solved1.3KViews0likes5Comments