Forum Discussion
rbustamante
Helper I
Helper ICalculate difference between columns in matrix visual
I have the following matrix visual: I need two things when the user clicks on the "Date slicer": 1) dynamically calculate the difference between the ammount of two dates. Ammount of 31/12/202...
Hi rbustamante ,
Based on the data you provided here:
mDifference = VAR _CurrentDate = SELECTEDVALUE ( 'Products (2)'[Date]) VAR _PreviousDate = CALCULATE ( MAX ( 'Products (2)'[Date] ), ALLSELECTED ( 'Products (2)'[Date] ), KEEPFILTERS ( 'Products (2)'[Date] < _CurrentDate ) ) VAR _ThisMonth = CALCULATE ( SUM ( 'Products (2)'[Amount] ) ) VAR _PreviousMonth = CALCULATE ( SUM ( 'Products (2)'[Amount] ), 'Products (2)'[Date] = _PreviousDate ) RETURN _ThisMonth - _PreviousMonthRegards,
AntrikshSharma
Community Champion
Community Championrbustamante Should be pretty easy, share a PBIX file with sample data.
rbustamanteThanks for your reply.
I try to explain better:
In this case I choose 3 dates and I need to know de difference between Ammount 31/03/2020 and 31/12/2019 and the difference between 30/04/2020 and 31/03/2020.
If I choose different dates I need to know the diferences between amounts at these dates.
I share the file
- rbustamante
Sorry it is not posible to share the pbix file