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!
I am reporting on the number of devices per tenant over time. I want to add a third column to the matrix below, showing the the difference between the number of devices per tenant between today and the same date last week. I download data to the report once a week.
I have created a matrix in Power BI with the following data:
Rows: Tenant
Columns: Date
Values: Devices (count)
This is how far I have come (filtered on Top N = 2 latests dates). Can anyone help me adding a new column to this matrix with the difference/delta between the columns below?
Solved! Go to Solution.
Hello:
Assuming you have measure to Count the devices like Total Devices = SUM(Table[Devices])
You can use DATEADD to get the figure from 7 days ago when you are looking at a particular date.
Sorry then
subtract the two.
Difference = [Total Devices] - [Devices 1 week ago] (the DATEADD measure I just mentioned)
Hi again!
A follow-up on this one. I used this function to calculate the number of devices a week ago:
Hi Ali-S:
When I look at the 94 as one week ago for 4-05-2021 , the week before looks like 3-30-2021 which is 94?
I think if you sort your weeks it will look better.
Just want to ask if the Tenant column is from your Date Table? The Data table would be marked as such and has a relationship with your fact table.
If you want to provide example file I'm happy to check it out from that perspective.
Thanks a bunch! It worked 😄
Your welcome. Great!
Hello:
Assuming you have measure to Count the devices like Total Devices = SUM(Table[Devices])
You can use DATEADD to get the figure from 7 days ago when you are looking at a particular date.
Sorry then
subtract the two.
Difference = [Total Devices] - [Devices 1 week ago] (the DATEADD measure I just mentioned)
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 |
---|---|
43 | |
25 | |
19 | |
15 | |
8 |
User | Count |
---|---|
58 | |
50 | |
44 | |
21 | |
19 |