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.
Hello guys,
I was looking at a method to compare 2 values (of the column Total) separated by 1 Week.
The data are the number of Stars of different Apps. I just want to have the number of new stars by week and by app.
For example:
Hive: on the 24/09/2018, I want a new column with the value: 8 (=7264 - 7256)
Thank you for your help !
Here it is my table:
Date Brand 1Star 2Star 3Star 4Star 5Star Total Objective Average
24/09/2018 | Hive | 2469 | 806 | 830 | 1072 | 2087 | 7264 | 4 | 2,931442731 |
24/09/2018 | Legrand Thermostat | 2 | 0 | 0 | 3 | 11 | 16 | 4 | 4,3125 |
24/09/2018 | Qivivo Thermostat | 36 | 21 | 22 | 34 | 12 | 125 | 4 | 2,72 |
24/09/2018 | Somfy | 6 | 5 | 24 | 92 | 148 | 275 | 4 | 4,349090909 |
24/09/2018 | Netatmo Energy | 487 | 251 | 363 | 1935 | 6832 | 9868 | 4 | 4,456627483 |
24/09/2018 | Ween | 1 | 0 | 0 | 4 | 13 | 18 | 4 | 4,555555556 |
24/09/2018 | tado° | 998 | 512 | 1546 | 6514 | 21760 | 31330 | 4 | 4,516948612 |
17/09/2018 | Somfy | 6 | 5 | 21 | 90 | 146 | 268 | 4 | 4,361940299 |
17/09/2018 | Qivivo Thermostat | 35 | 21 | 22 | 34 | 12 | 124 | 4 | 2,733870968 |
17/09/2018 | Netatmo Energy | 486 | 252 | 365 | 1922 | 6765 | 9790 | 4 | 4,453319714 |
17/09/2018 | Hive | 2467 | 804 | 828 | 1070 | 2087 | 7256 | 4 | 2,931918412 |
17/09/2018 | Ween | 1 | 0 | 0 | 4 | 13 | 18 | 4 | 4,555555556 |
17/09/2018 | tado° | 984 | 506 | 1541 | 6433 | 21511 | 30975 | 4 | 4,516739306 |
17/09/2018 | Legrand Thermostat | 1 | 0 | 0 | 3 | 11 | 15 | 4 | 4,533333333 |
10/09/2018 | Hive | 2461 | 797 | 824 | 1067 | 2083 | 7232 | 4 | 2,932798673 |
10/09/2018 | Legrand Thermostat | 1 | 0 | 0 | 3 | 11 | 15 | 4 | 4,533333333 |
10/09/2018 | Ween | 1 | 0 | 0 | 4 | 13 | 18 | 4 | 4,555555556 |
10/09/2018 | Qivivo Thermostat | 35 | 21 | 22 | 34 | 12 | 124 | 4 | 2,733870968 |
10/09/2018 | Somfy | 6 | 5 | 19 | 89 | 141 | 260 | 4 | 4,361538462 |
10/09/2018 | Netatmo Energy | 484 | 252 | 362 | 1902 | 6721 | 9721 | 4 | 4,452936941 |
10/09/2018 | tado° | 967 | 500 | 1526 | 6378 | 21250 | 30621 | 4 | 4,51673688 |
Solved! Go to Solution.
Hi,
I think this column would work (replace Table1 with your table name...):
column = [Total] - SUMX(FILTER(Table1, [Brand] = EARLIER([Brand]) && (EARLIER([Date]) - [Date])= 7), [Total])
Hi,
I think this column would work (replace Table1 with your table name...):
column = [Total] - SUMX(FILTER(Table1, [Brand] = EARLIER([Brand]) && (EARLIER([Date]) - [Date])= 7), [Total])
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 |
---|---|
114 | |
105 | |
79 | |
68 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
82 | |
70 |