Hey ppl,
i am wondering wether i can get the weeknumber into my formated date or not... let me explain that further:
1. i got a datetable connected to my other data with every date-data i need... year, month, weeknumber, day etc...
2. in my sheet where i want to create the measure i got the date written in a column "dd.mm.yyyy"
3. in that same sheet i now want to use create the measure using =format[date];(value) .... getting to the value i start struggeling. can i tell the dax that i want "weeknumber.yyyy"???? Is that even possible? If it is, what is the shortcut for weeknumber??
Why do i need this? I got several price data from different years in different weeknumbers. All the prices are liste in ONE column.
So i want to create a measure with different time stamps to differentiate between every possible combination inbetween weeknumbers and years as filter .... since the weeknumber is the same every year i need the year related as well to enable the difference inbetween weeknumbers...
Thanks a lot 🙂
Cheers
