compare selected value with calculated column value

[nagasaikumarb22]

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

[Anonymous]

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]

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.