Compare two selected Months MTD

[qlikwiz123]

I have Month (MMM-YY) and Date (MM/DD/YYYY)  and ID columns.

I need to show the difference in ID Count between any two user-selected Months MTD. For example, if a user selects Aug-23 and May-22, since we only have data until the 2nd of Aug-23, it should compare May 1 to 2 2022 count with Aug 1 to 2 2023. (MTD vs MTD). If the user selects Jan-23 and Mar-23, since we have data for all the dates in two months, MTD would be Jan 1 to 31 2022 vs March 1 to 31 2023

[jayanttibhe]

you saying " since we only have data until the 2nd of Aug-23" meaning this broken month scenario is only for the latest month rest everything has all the in-scope dates even we don't have FACT data for some of the dates, right? 

[qlikwiz123]

@jayanttibhe Theoretically yes. Since today is August 2, 2023, we may only have data until August 1, 2023. So when a user selects 2 random months for comparison, for example, May 2023 and August 2023, it is only fair to compare May 1st, 2023 data with August 1st, 2023 data (MTD) instead of comparing May 1 to 31 2023 vs August 1, 2023, data.

If the user picks any other months from the past (Jan 2023 and Mar 2023), since they are in the past and assuming they have data for all the dates, we should compare Jan 1 - 31 2023 Count(ID) data vs Mar 1 - 31 2023 Count(ID) data