Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Get the average percent from 2 different columns

Hello!   So I got these columns with this formula that I would like to combine to get the average percent of the stuff thats "Avklarat".   2tim = IF('logg'[Time]>1/24/60*120;"Missat";"Avklarat")...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello!

 

Sorry, but i'm new to this and I dont really get it. I tried this but it wont work:

 

New Table = 
SUMMARIZE (
    'Logg';
    'Logg'[2tim];
    'Logg'[1tim];
    "Average percent"; MAX ( 'Logg'[Average percent] )
)