topic Re: How to fetch beginning date and ending date to the measure in DAX Commands and Tips

How to fetch beginning date and ending date to the measure

Anonymous — Tue, 03 May 2022 19:21:42 GMT

Hello,

I have table named 'Calendar'

It has colums named: CalendarDate, CalendarWeekBeginningDate, CalendarWeekEndingDate

In order for example: 05/02/22, 05/02/22, 05/08/22
05/01/22, 04/25/22, 05/01/22

Today is 5/2/2022 and still we are in the week. I want to get 04/25/22, 05/01/22 as _weekBeginingPriorWeek and _weekEndingPriorWeek in a DAX function to use as variables.
When Today is 5/8/2022 I want to get 05/02/22, 05/08/22 as _weekBeginingPriorWeek and visa versa

I use AAS model to create DAX measures, how can i get those two specific days ?

Re: How to fetch beginning date and ending date to the measure

Anonymous — Tue, 03 May 2022 19:49:34 GMT

Measure = CALCULATE(

DATEADD('Calendar'[CalendarWeekBeginningDate],0,DAY),

FILTER('Calendar',

'Calendar'[CalendarDate] = TODAY()-7

)

)

I just come up with this solution, It gaves me what I want but I'm not sure
any comments?

Re: How to fetch beginning date and ending date to the measure

tackytechtom — Tue, 03 May 2022 20:19:56 GMT

Hi Anonymous ,

How about this:

weekBeginingPriorWeek = 
TODAY() - 6 - WEEKDAY( TODAY() ,2)

weekEndingPriorWeek = 
TODAY() - WEEKDAY( TODAY() ,2)

Not sure whether you wanna use the formulars as above meaning based on todays date, or if you'd like to use your own date column. If the latter fits your case, then just substitute TODAY() with whatever date column you have in your model 🙂

Let me know if this helps!

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

Re: How to fetch beginning date and ending date to the measure

Anonymous — Tue, 03 May 2022 20:32:02 GMT

For example : 1st column how many items sold on that day, 2nd column calendar date, 3rd column 1st category item.

Actually, I'm gonna use those 2 variables in a dax function to filter in the first column
such as bring me the how many sold item between those two variables ( beginning date of prior week " monday" to ending date of prior week "sunday" )

What I shared the Dax code brings me the total, not seperated day by day.

Re: How to fetch beginning date and ending date to the measure

Anonymous — Tue, 03 May 2022 20:45:55 GMT

I guess It works

I need to try it on again.