Forum Discussion

nagasaikumarb22's avatar
nagasaikumarb22
Helper I
3 years ago

compare selected value with calculated column value

I had date filter and selected date value should be compared against endorsement date for getting upto slected date records.Is there any possibility.

Thanks in advance

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi nagasaikumarb22 ,

    If I understand your question correctly, you can achieve this by creating a measure that filters the data based on the selected date value and the endorsement date.

    Measure =
CALCULATE (
    SUM ( Table1[Value] ),
    Table1[Endorsement Date] <= MAX ( Table1[Selected Date] )
)

     

    How to Get Your Question Answered Quickly 

     

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    Best Regards
    Community Support Team _ Rongtie

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

     

     

     

    • nagasaikumarb22's avatar
      nagasaikumarb22
      Helper I
      3 years ago

      I dont need any aggreagte function like sum of table[value] I need Logical conditional check between measure and column.

      Endorsement date here is calculated column where as selected date is a measure.