Need help

[emmanuelkamara1]

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:

[littlemojopuppy]

Define "growth"

and all the sample data you provided is as of the same date...going to make it awfully difficult to help

[amitchandak]

@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-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8