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.
For each row, I want to get a unique following number per Focus Tank. In Excel I accomplisted this by a COUNTIFS statement:
COUNTIFS if:
Column [Focus Tank] matches the [Focus Tank] value of the current row.
Column [NewStart] is less than or equal to the [NewStart] value of the current row.
Works a charm.
In PowerBI I came up with this, but it is not functioning because I don't know how to make code "VALUE(45907.74585)" dynamic. Meaning, this value should get the value from it's current ROW, and not be hardcoded. Anyone know what I'm missing here?
Thanks!
Solved! Go to Solution.
Hi, @SteveMBSDO
transaction =
var a = 'transaction database'[datetime chrono]
return
countx(
filter('transaction database',
'transaction database'[focus tank]=30 &&
'transaction database'[datetime chrono]< a
),
'transaction database'[datetime chrono]
)
HI, @SteveMBSDO
if it is measure then try below
measure =
var a = max(tablename[column name from value coming])
and compare it like (<a instead of values(...))
code like
measure =
var a = max(tablename[column name from value coming])
return
countx(
..........,
.....[datetime chrono]<a
)
if its column then
var a = tablename[column name from value coming]
Hi, @SteveMBSDO
transaction =
var a = 'transaction database'[datetime chrono]
return
countx(
filter('transaction database',
'transaction database'[focus tank]=30 &&
'transaction database'[datetime chrono]< a
),
'transaction database'[datetime chrono]
)
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 |
---|---|
56 | |
27 | |
24 | |
14 | |
9 |
User | Count |
---|---|
77 | |
61 | |
47 | |
17 | |
12 |