Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi, please give me some help.
The column's values are continuous but they were broken by 0.
I need to use the maximum value(58640715) to subtract the earliest value(58636780). Max(turnover)-earliest(value)
Could you please tell me how to filter the earliest value(58636780)?
The columns likes this.
Thanks,
Solved! Go to Solution.
Hi @Bridge ,
Are you trying to calculate the max value and min(except 0) value for the same match_ID?
If so you could try this formula:
column =
VAR _max =
CALCULATE (
MAX ( 'table'[turnover] ),
ALLEXCEPT ( 'table', 'table'[match_id] )
)
VAR _min =
CALCULATE (
MIN ( 'table'[turnover] ),
FILTER ( ALLEXCEPT ( 'table', 'table'[match_id] ), 'table'[turnover] <> 0 )
)
RETURN
_max - _min
If I misunderstood your meaning, please share more details.
Best Regards,
Jay
Hi @Bridge ,
Are you trying to calculate the max value and min(except 0) value for the same match_ID?
If so you could try this formula:
column =
VAR _max =
CALCULATE (
MAX ( 'table'[turnover] ),
ALLEXCEPT ( 'table', 'table'[match_id] )
)
VAR _min =
CALCULATE (
MIN ( 'table'[turnover] ),
FILTER ( ALLEXCEPT ( 'table', 'table'[match_id] ), 'table'[turnover] <> 0 )
)
RETURN
_max - _min
If I misunderstood your meaning, please share more details.
Best Regards,
Jay
Hi,
Show the exact result you are expecting. Also, share data in a format that one can work on
Sorry for my unclear description.
I want to get the result of the maximum value - the earliest value
The Earliest value(58636780) happened on 2022-05-24 00:15:00.000. It's the earliest value that happened on the day.
I use the Max function to find the max value(58640715). But I don't know how to write the function to find the earliest value.
Hi,
Do you want this as a calculated column formula or as a measure in the visual. Share the download link of your PBI file.
I ever used the formula like
MINX(Filter(Table, MIN(DateTime), Turnover),
But it didn't work.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
108 | |
108 | |
108 | |
90 | |
61 |
User | Count |
---|---|
171 | |
138 | |
132 | |
102 | |
86 |