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
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi waqarqtrz ,

 

Please try these measures:

 

$ External2 = 
VAR __min_date = MIN('dbDates'[Date])
VAR __max_date = MAX('dbDates'[Date])
VAR __result = CALCULATE([$ External], ('TMO_Table Data'[TransactionDate]<=__min_date && 'TMO_Table Data'[PaidOffDate]>=__max_date) || 'TMO_Table Data'[PaidOffDate]=BLANK())
RETURN
    __result
$ Internal2 = 
VAR __min_date = MIN('dbDates'[Date])
VAR __max_date = MAX('dbDates'[Date])
VAR __result = IF( NOT ISBLANK([$ External2]), CALCULATE([$ Internal] + 0, ('TMO_Table Data'[TransactionDate]<=__min_date && 'TMO_Table Data'[PaidOffDate]>=__max_date) || 'TMO_Table Data'[PaidOffDate]=BLANK()))
RETURN
    __result
$ Total = [$ External2] - [$ Internal2]

 

If I misunderstood your question, please feel free to contact me.

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum