Forum Discussion
Helper IGet the repeating names monthly
Hi ,
I have training names column and date column. I need to know which training is repeating monthly.(for example if the power BI training is conducted in both march and april , then i need to get power BI as result ).please help me achieving this.
Thanks in Advance,
Radhika.
9 Replies
ryan_mayuSuper User
could you pls provide some sample data and expected output?
Radhika123Thanks for the reply ryan_mayu
Sure, the data is like,
Training Name Month Attendee
Power BI March John
Power BI March William
power BI April Jack
Power Apps March Jack
Power Apps March henry
Result will be like
Month Training Name Result
March Power BI 2
April Power BI 2
March Power Apps 1
As the power Bi repeated in both march and april , it should be 2 and the power apps is in only one month so it should be 1- ryan_mayu
you can create a measure
Measure = CALCULATE(DISTINCTCOUNT('Table'[Month]),ALLEXCEPT('Table','Table'[Training Name]))