Forum Discussion
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
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.
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.