topic DatesBetween Function in DAX Commands and Tips

DatesBetween Function

RaghdahIsmael — Sun, 02 Oct 2022 22:06:02 GMT

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

Re: DatesBetween Function

Greg_Deckler — Mon, 03 Oct 2022 00:34:13 GMT

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/434008

Re: DatesBetween Function

RaghdahIsmael — Mon, 03 Oct 2022 00:45:31 GMT

thank you Greg for your reponse , i will try the solutions you listed for me and i will let you know !

Re: DatesBetween Function

RaghdahIsmael — Mon, 03 Oct 2022 17:29:04 GMT

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,