Forum Discussion

waqarqtrz's avatar
waqarqtrz
Frequent Visitor
1 year ago

Filtering my Table visual by comparing 2 Date Fields

I currently have Visuals as follows:   Date Filter (slider in between two dates) from my dedicated Date Table and field: dbDates[Date] - There's a Min value and Max value Assume the filters are s...
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
1 year ago

Hi waqarqtrz ,

 

What you need is to create a measure that gets the calculated value for you.

I assume you have a calendar table on your model, if not you need one to do the calculation then just add a measure similar to this one:

Total Value = CALCULATE(SUM(TMO_Table[$ Amount]), TMO_Table[TransactionDate] >= MIN('Calendar'[Date]) && TMO_Table[TransactionDate] <= MAX('Calendar'[Date]))

This should give you the interaction between the values and the slicer that you need.

The creation of a column in your model is not interactive with selection in slicers in this caswe you min(date) will always get the same value and not be dynamic