Forum Discussion
Helper VCompare date/time periods
Hi,
I have to make a report that compares data from different time periods. I know I can use a date filter, but I need the data of the periods in 1 table.
The periods change from year to year, f.e:
period 1: 16 october 2017 - 23 march 2018
period 2: 19 october 2018 - 19 march 2019
period 3: 21 october 2019 - 21 march 2020
Can someone help me out?
jochendecraene you can explore the technique defined in this post.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
5 Replies
- parry2k
Super User
jochendecraene you can explore the technique defined in this post.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
jochendecraeneparry2k thnx, this worked for me!
- lbendlin
Does your Dates table have a column that identifies the period?
- jochendecraene
lbendlin the periods are not specified. I have the data on a daily basis.
- parry2k
jochendecraene well somewhere you have to define the logic for the period, how you expect it work without defining the period.
it is ok if you have data by date,
