Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Okay i am just dumb and solved it by myself.... ofc it is just "ww" for the week... dear lord:D
Okay i am just dumb and solved it by myself.... ofc it is just "ww" for the week... dear lord:D
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |