Forum Discussion
JP-Ronse
Helper II
8 years agoWeeknum and other questions
Hi, Given: ReactionTime is a calculated column: =value([Creation Time])-value([Event Date]) WeekNum: =WEEKNUM([Creation Time];21) The DAX reference does not mention 21 as param...
- 8 years ago
Hi Ashish,
I found a solution to all my questions.
ISO using WeekNum in PQ I used WeekNum in PP and that function has the ISO option.
The easiest way to group 5 running weeks was using a slicer.
Kind regards,
JP Ronse
Ashish_Mathur
Super User
8 years agoHi,
Glad to see you here as well. I will need some data to work with. Please share a dummy dataset and also show your result there.
JP-Ronse
Helper II
8 years agoHi Ashish,
I found a solution to all my questions.
ISO using WeekNum in PQ I used WeekNum in PP and that function has the ISO option.
The easiest way to group 5 running weeks was using a slicer.
Kind regards,
JP Ronse