Forum Discussion
Need help
Hi all, can someone help me get a fuction to compare the weekly revenue growth/monthly revenue growth and yearly reevenue growth? Below is a sample data
| Revenue | date |
| 200 | 2016-03-15 11:27:05 |
| 4000 | 2016-03-15 11:40:07 |
| 30000 | 2016-03-15 11:51:45 |
| 123399 | 2016-03-15 12:03:40 |
| 12344 | 2016-03-15 12:16:13 |
| 8888899 | 2016-03-15 12:21: |
2 Replies
emmanuelkamara1 , Create a date from current datetime
New date = [date].date
or
Date = date(year([date]),month([date]),day([date]))For Year, Month and week refer my video or Blogs , You need to join this new date with date table
Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA
Power BI — Qtr on Qtr with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-qtd-questions-time-intelligence-2-5-d842063da839
https://www.youtube.com/watch?v=8-TlVx7P0A0
Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8Define "growth"
and all the sample data you provided is as of the same date...going to make it awfully difficult to help
