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.
As a TV provider, we get reports on viewership of specific channels on specific days. However, if someone watches a recording (DVR), it shows as channel 1000.
I am looking at creating a column that IF it sees it is channel 1000, it will search by the channel name and pull in the channel number, not to include channel 1000.
In the ex below, 327 is 5StarMax - and contains details for that day.
1000, below it - I would like to pull in that it is channel 327, in a new column (last column as of now).
- Hopefully this makes sense - Thank you!
Solved! Go to Solution.
@mmoroni , A new column like
maxx(filter(table, [channel] =earlier([channel]) && [ch#] <> 100),[ch#])
or
if([ch#] =1000,maxx(filter(table, [channel] =earlier([channel]) && [ch#] <> 100),[ch#]), blank())
Ch# currently shows 1000. I need a new column, [DVRch#]. If Ch#=1000, vlookup [channelname] and return value from [Ch#], excluding 1000
So in the case above, I want the 2nd line to search for the same channel name, and return the first value that is NOT 1000. IE, I want this one to return "327"
In the example above, i just wrote:
@mmoroni , A new column like
maxx(filter(table, [channel] =earlier([channel]) && [ch#] <> 100),[ch#])
or
if([ch#] =1000,maxx(filter(table, [channel] =earlier([channel]) && [ch#] <> 100),[ch#]), blank())
Thank you so much!!!! I used the IF statment, so i could leave the NON 1000's blank.
@mmoroni , output column is not clear to me
as of now it is
if([Ch#]=1000, true(), false())
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 |
---|---|
113 | |
97 | |
79 | |
73 | |
56 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |