Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I am trying to replace blank values in the column "value" with the max value if country = US.
It is working fine if i enter replacement value as integer.
Columns in Table A: Key, Country, Value
Columns in Table B: Key, Country, Sales
Thanks in advance!
Alright so this is how i resolved it.. Might not be the smartest way but it worked
Created a variable '_num' : this contains the max value of column [Value] when country is US
@Anonymous
write
if(isblank('Table A'[ Value]) , _num,'Table A'[ Value])
hi,
I had initially tried this out but it did not work - check the original screenshot.
However for now i was able to solve it.
Thanks
Dear friend , You can use
Replace = IF (ISBLANK(Values) , 0 ,Values)
This will help
Please give appreciation by pressing kudos button
And if it helped please accept this post as an answer
If you didn't get to answer
Please tag me I'll be more than happy to help you !
Regards
Sujit
Dear @Anonymous ,
I hope you reached your goal
Please accept my post as solution , if it helped , if you have doubt feel free to tag and reply 😁
Regards ,
Sujit Thakur
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |