Forum Discussion
Weekly data - can you still use Time Intelligence functions?
The lowest level of my current dataset is by week so I am not able to join it to a Date table in atypical way. I need to be able to add a lot of time functions such as TotalYTD and Running tot...
Hi,
If the week number is 2, then 2-1=1. 1*7=7. & days added to the first day of the first week would be first day of the second week. This logic continues.
For 2 years, try this calculated column formula
=IF(YEAR(Data[Week Number])=2017,DATE(2017,1,1)+7*(Data[Week Number]-1),DATE(2018,1,1)+7*(Data[Week Number]-1))
Hope this helps.
Ashish_Mathur
Super User
Super UserYou are welcome. Please don't just type the formula. Explain the question, show the data and also the expected result. Share the link from where i can download the file.
Sure, I will do. I'll mark this as the solution and open a new thread if I need to.
Thanks again.
- Ashish_Mathur
You are welcome.