Changing data format according to the data used

Question & Answer
, ,
4

For Week, Month and Quarter you could use:
ifelse(
${seasonality} = ‘Week’, dateDiff(truncDate(“WK”, truncDate(‘YYYY’, {Order Date})), {Order Date}, ‘WK’)+1,
${seasonality} = ‘Quarter’, dateDiff(truncDate(“Q”, truncDate(‘YYYY’, {Order Date})), {Order Date}, ‘Q’)+1,NULL)
Like here explained: Week Numbers (1-53) - Learning Center / Articles - Amazon QuickSight Community
I am not yet sure how to combine the day part in it but I try to look into it