Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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: |
Define "growth"
and all the sample data you provided is as of the same date...going to make it awfully difficult to help
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |