Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Column value from date row

Hi 

Could you help

I would like to calculate a measure to show the value (price) in a column for todays date minus the value on 8/1/2024.

Can you show to create a measure of this.

Table: 1

DatePriceItem
31/12/20235.33Hat
08/01/20247.10Coat
10/07/202411.30Show

 

Thanks

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

    Based on my testing, please try the following methods:

    1.Create the sample table.

    2.Create the new measure to calculate the value.

    Price minus = 
var _today = TODAY()
VAR TargetDate = DATE(2024,1,8)
var _toprice = CALCULATE(SUM('Table'[Price]), 'Table'[Date] = _today)
var _tarprice = CALCULATE(SUM('Table'[Price]), 'Table'[Date] = TargetDate)
RETURN
_toprice - _tarprice

    3.Drag the measure into the card visual. The result is shown below.

     

    Best Regards,

    Wisdom Wu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

    Based on my testing, please try the following methods:

    1.Create the sample table.

    2.Create the new measure to calculate the value.

    Price minus = 
var _today = TODAY()
VAR TargetDate = DATE(2024,1,8)
var _toprice = CALCULATE(SUM('Table'[Price]), 'Table'[Date] = _today)
var _tarprice = CALCULATE(SUM('Table'[Price]), 'Table'[Date] = TargetDate)
RETURN
_toprice - _tarprice

    3.Drag the measure into the card visual. The result is shown below.

     

    Best Regards,

    Wisdom Wu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.