Forum Discussion
Radhika123
Helper I
2 years agoGet 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 ...
Radhika123
Helper I
2 years agoThanks 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
Super User
2 years agois the month column from the date table or fact table?
- Radhika1232 years ago
Helper I
Hi ryan_mayu
it's from fact table only.- ryan_mayu2 years ago
Super User
maybe you can try to distinctcount (month), not the date to see if this can show the correct output
- Radhika1232 years ago
Helper I