Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hi,
My table visual looks like this (Where "Count id" is a count of the records in that time interval and "Count id -5" should be a measure):
What I need is the count of ids for the previous interval. Expected output for "Count id -5":
Interval | Count id | Count id -5 |
4/23/2023 12:05:00 AM | 343 | 251 |
4/23/2023 12:10:00 AM | 291 | 343 |
4/23/2023 12:15:00 AM | 241 | 291 |
4/23/2023 12:20:00 AM | 241 | 241 |
4/23/2023 12:25:00 AM | 254 | 241 |
4/23/2023 12:30:00 AM | 239 | 254 |
Hope someone can help me out, thanks in advance!
Best,
Solved! Go to Solution.
Hi @jppv20,
Can you try the following?
Count ID - 5 =
CALCULATE(
[Count Id],
OFFSET(
-1,
,
ORDERBY( Table[Interval], ASC )
)
)
If I answered your question, please mark my post as a solution.
Best,
Hi @jppv20,
Can you try the following?
Count ID - 5 =
CALCULATE(
[Count Id],
OFFSET(
-1,
,
ORDERBY( Table[Interval], ASC )
)
)
If I answered your question, please mark my post as a solution.
Best,
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!