Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi,
I wonder if anyone can help.
I am trying to construct a new column. I want it to do:
IF the status is complete AND the BH_c is null then take the median of all the BH's and put it in here
ELSE just use BH_c
I am trying this using the following M code
if List.AllTrue(
{ [Status]="Completed", [BH__c]=null }
) then List.Median({[BH__c]})
else [BH__c]
It is valid but where the status is complete AND the BH is null it displays NULL I think this is becuase it is just looking at the row in question and the median of null is null.
Has anyone got any idea on how to get this to work?
Thanks!
Solved! Go to Solution.
Within the List.Median function, you should have <PreviousStep>[BH_1] instead of {[BH_1]}
Within the List.Median function, you should have <PreviousStep>[BH_1] instead of {[BH_1]}
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
84 | |
75 | |
68 | |
41 | |
35 |
User | Count |
---|---|
102 | |
56 | |
52 | |
46 | |
40 |