Forum Discussion

wemsomba10's avatar
wemsomba10
Frequent Visitor
1 year ago
Solved

DEALING WITH START AND END DATES

Hello guys,   I have a start and end date columns below.   Account ID         Start Date     End Date   1234                 1/25/2022      3/25/2022   5678                 2/11/2023      9/10/2...
Need Help
  • Ashish_Excel's avatar
    Ashish_Excel
    1 year ago

    Hi,

    Download the PBI file from here.

    Hope this helps.

     

wemsomba10's avatar
wemsomba10
Frequent Visitor
1 year ago

the second part of the filter should be a combination of and and or.  && data[endate] >Max(calendar[date] || ISBLANK(data[enddate]). I am unable to use a third criteria ina filter function.

Ashish_Excel's avatar
Ashish_Excel
Solution Supplier
1 year ago

Study my solution carefully.  You will not need that second condition.