Comparing all available expiry dates in dataset with the date derived using measure

[Anonymous]

Hi All,

I have a Medicine_Master table with a column - "Expiry Date". I want to compare these expiry dates with a derived date using the measure. This data is to be represented using the Table visual.

The following are some basic dates:
          1) Analysis Date = First date of the selected month and year using respective slicers.
          2) Future Comparison Date = Analysis Date + 7 months (This date is calculated using measure: EOMONTH(Analysis Date, 7)

Now, the condition is that, if an "Expiry Date" is less than or equal to the "Future Comparison Date", the 'Will Expire?' will be 'Yes' otherwise 'No'.

This comparison will be done for all 'Lot Numbers' existing in the data table. This data is to be furnished in the Table visual.

In the screen shot, all expiry dates are shown in the 'Plan Expiry Date' column. This date is to be compared with 'Future Comparison Date'. And comparison result is to be displayed in the 'Will Expire?' column. You can see that the first 3 rows having the plan expiry date should be having 'Yes' instead of 'No'!!

When I select May-2023, the first three rows shoul show 'Yes' in 'Will Expire?' column.

When I select Oct-2023, all the lot numbers having planned date less than Jun-2024 should show 'Yes'.

I have tried a lot to get the desired output but failed every time!! Please help me to get it done!

@amitchandak: Hello sir... 🙂. Please help me with this.

[Anonymous]

Hi @parry2k / @amitchandak

Please help me on this. 🙂