Forum Discussion

Radhika123's avatar
Radhika123
Icon for Helper I rankHelper I
2 years ago

Get 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 ...
Need Help
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
2 years ago

could you pls provide some sample data and expected output?

Radhika123's avatar
Radhika123
Icon for Helper I rankHelper I
2 years ago

Thanks 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's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    2 years ago

    you can create a measure

    Measure = CALCULATE(DISTINCTCOUNT('Table'[Month]),ALLEXCEPT('Table','Table'[Training Name]))
     
    • Radhika123's avatar
      Radhika123
      Icon for Helper I rankHelper I
      2 years ago

      Thanks ryan_mayu for the reply
      but I apply the same , I'm getting all the months upto december but my data is upto may only and the measure is showing 12 for all  the trainings.Please check the snap shots below .please clarify why I am getting like this 

      And the measure I have given is same like as you have given 

       

      • ryan_mayu's avatar
        ryan_mayu
        Icon for Super User rankSuper User
        2 years ago

        is the month column from the date table or fact table?