Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have used the above data as an example and I am wondering if it is possible to do the following ?
1) Find all countries for which discount band is low and save this list as a variable
2) Then for all countries in this list, populate a new column with value Y if the country column is in the list.
The pseudocode is as follows:
list = countries where discount band is low
for x in rows
if x[Country] is in list:
populate new column with value Y
END
Is this possible ?
Solved! Go to Solution.
@Anonymous , In case you need a new column havin value of value column, you can have new column like
low value = var _tab = summarize(filter(Table, Table[Discount band] = "Low") , [Country])
return
if([country] in _tab , [Value], blank())
@Anonymous , In case you need a new column havin value of value column, you can have new column like
low value = var _tab = summarize(filter(Table, Table[Discount band] = "Low") , [Country])
return
if([country] in _tab , [Value], blank())
User | Count |
---|---|
124 | |
106 | |
99 | |
63 | |
59 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |