Forum Discussion
Calculating Variation per Month
Hi, I have a list of 35 000 sentences from which I extracted key words. For each sentence, I have a rate and the date, from 2010 to 2019. I would like to be able to see which are the keyword...
Hi Anonymous
It seems you may try to use ALLEXCEPT function.If it is not your case,please follow the How to Get Your Question Answered Quickly to post your simple assumed data and expected output.
Reference:https://www.sqlbi.com/articles/using-allexcept-versus-all-and-values/
Measure = CALCULATE ( AVERAGE ( Table[Rate] ), ALLEXCEPT ( Table, Table[Year], Table[Month] ) )Regards,
Hi Anonymous
It seems you may try to use ALLEXCEPT function.If it is not your case,please follow the How to Get Your Question Answered Quickly to post your simple assumed data and expected output.
Reference:https://www.sqlbi.com/articles/using-allexcept-versus-all-and-values/
Measure =
CALCULATE (
AVERAGE ( Table[Rate] ),
ALLEXCEPT ( Table, Table[Year], Table[Month] )
)
Regards,