Forum Discussion
DatesBetween Function
Hello DAX Community,
I'm trying to write 2 meaures using DatesBetween Function as the following :
1. Itemsof2022 = Calculate(Sum('ItemsData'[# of Items]),Datesbetween('Date Dimension'[Date],DATE(2022,01,01),TODAY())).
The above function implemented successfully as the below visual , though it didn't give me the September data , i have to figure out later.
2. As for this measure : Itemsof2021 = Calculate (Sum('ItemsData'[# of Items]),Datesbetween('Date Dimension'[Date],DATE(2021,02,01),DATE(2021,12,31))) , this one didn't get implemented and it shows me the below error .
<ccon> A circular dependency was detected: ItemsData [Itemsof2021], ItemsData [Itemsof2022] , ItemsData [Itemsof2021] . </ccon>
I don't understand why it says dependency here , there is no dependency between the above 2 measures [Itemsof2021] and [Itemsof2022] beacuse bascially i'm trying to see the SUM of the column [# of Items] based on each year seperatly ; 2021 and 2022.
can you help please in this regard.
thanks
3 Replies
thank you Greg for your reponse , i will try the solutions you listed for me and i will let you know !
RaghdahIsmael TI functions are bad. You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000
Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008Hello 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,
