Forum Discussion
Helper IIIUnique Visits by Months
Dear All,
Kindly please see the attached Data files. I just need to get unique visit counts by monthly as shown below. Could you please help me to get this in Power BI. My data (A:B),
I am using exact formular in excel to do this.
Kindly help me to do it in Power BI.
You should just have to put the MONTH of BeginDateofService in a table along with the distinct count of VisitFID. Just change your default aggregation for VisitFID to Count (Distinct) or choose that aggregation when you drag it into your visual. Or, create a measure that uses that DISTINCTCOUNT function:
https://msdn.microsoft.com/en-us/query-bi/dax/distinctcount-function-dax
3 Replies
- Greg_Deckler
Community Champion
You should just have to put the MONTH of BeginDateofService in a table along with the distinct count of VisitFID. Just change your default aggregation for VisitFID to Count (Distinct) or choose that aggregation when you drag it into your visual. Or, create a measure that uses that DISTINCTCOUNT function:
https://msdn.microsoft.com/en-us/query-bi/dax/distinctcount-function-dax
v-jiascu-msftMicrosoft Employee
Sansudhi8Thank you