Forum Discussion
DatesBetween Function
Hello Everyone,
The above issue has not been fixed , i tried all the ways explained in the above but still didn't work !!
i tried to fprmulate the below mesaures from :
- Itemsof2021 =Calculate (Sum('ItemsData'[# of Items]),Datesbetween('Date Dimension'[Date],DATE(2021,02,01),DATE(2021,12,31))
- Itemsof2022 = Calculate(Sum('ItemsData'[# of Items]),Datesbetween('Date Dimension'[Date],DATE(2022,01,01),DATE(2022,08,31))
Into the following :
- Itemsof2022 = Calculate(Sum('ItemsData'[# of Items]),PREVIOUSMONTH('Date Dimension'[Date]))
- Itemssof2021 = Calculate (Sum('ItemsData'[# of Items]),SAMEPERIODLASTYEAR(PREVIOUSMONTH('Date Dimension'[Date]))).
So basically , i want to replace the job of the filters in the below screenshot by using the sutable DAX, withiout havingme each month changing the filters on the visula manually 🤔
And Currently the below visual should present also August and September data on both sides
thank you in advance,