Forum Discussion
Creating a measure from values in two Date Slicers
You are welcome. If my reply helped, please mark it as Answer.
Community ChampionmusoQ Just want to clarify.... about your first example...
Company X = $50,000 + Company Y = $6,000 + Company Z = $24,000
How come the Compan Y value is $6000 ? It should be $12000 right ? Please confirm...
Thanks for the query PattemManohar the first example where Company Y is $6,000 is down to the slicer selection of 01/01/2018 to 31/12/2018.
Company Y donates $12,000 in total to be used from 01/07/2018 to 30/06/2019 (or $1,000 per month over a 12 month period).
When the slicer selections are set to Start Date 01/01/2018 and Finish Date 31/12/2018 this is only 6 months of Company Y's donation period (01/07/2018 and 30/12/2018) resulting in only $6,000 ($1,000 per month for 6 month period).
