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 have a problem,
i get my data via directquery but i want to calculate everytime with previous rows. I want to get the seconds between every rows.
Here is a example of it.
Thank you for your time
hi @mo12
try to plot the date1 column with a measure like:
MinuteDuration =
VAR _date = MAX(TableName[Date1])
VAR _datepre=
MAXX(
FILTER(ALL(TableName), TableName[Date1]<_date),
TableName[Date1]
)
RETURN
DATEDIFF(_datepre, _date, MINUTE)+0
it worked like this:
Please ensure to feed the Date1 column directly, instead of the date hierarchy.
@mo12 , You have to create a measure
datediff(maxx(filter(all(Table), Table[Date] < max(Table[Date]) ), Table[Date]) , Max(Table[Date]) , Second)
or
Sumx(Table, datediff(maxx(filter(all(Table), Table[Date] < max(Table[Date]) ), Table[Date]) , Max(Table[Date]) , Second) )
Do you know how i get this measure for only the rows that i got shown on my table and not for all of my over 1 000 000 rows?
I got this Error.
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 |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
69 | |
48 | |
44 | |
18 | |
15 |