How shows month on month visitors on a power BI Carc

[Anonymous]

Hello,

I would like to use a power BI card to show month on month visitor changes in a card.

Can this be done in DAX?

Please advise.

Kind regards,

Harrison

[scott_henderson · Accepted solution]

OK, what column are you currently using for your visitor count ?

Do you have a unique identifier for each visitor, if so just do a distinctcount on that column then use time intelligence features to achieve your outcome.

https://learn.microsoft.com/en-us/dax/distinctcount-function-dax

[Anonymous]

Thank you for this update.

I appreciate the help

[Anonymous]

Hi Scott,

Thank you for your response.

I do not have a pbix example that I can share.

Do you have a link to a video showing a distinct count of visitor ID

I have a calendar table which I have created an relationship to another table shown below. The idea is that I take the month on month date from the GA date.

[scott_henderson]

Several ways of doing this, do you have an example pbix for your dataset ?

You could do a distinct count of Vistor id, if you have one where month = current or last month assuming you have a date table and have or can add current month and last month ?  Or if looking for all months this can be achieved too.