Averagex on text strings

[ysherriff]

Hi all,

I have a dax function that sums up the total unique counts between dates. See image #1. I am trying to get an average. See image #2. But when I did, it give me an error message stating: The function Averagex can’t work with a value type string." How can I retrieve an average between date difference?

Thanks for your help

Image #1.

Image # 2

[Keith]

Did you check youtube?

there is a lot of youtube video that can help you on that.

I also found this in the Power bi community too

Average For String Data Type

thanks
Keith

[ysherriff]

Thanks Keith,

You beat to the punch. I had a trigger finger before posting.

[Keith]

hmmmm…maybe take some time researching before posting

[ysherriff]

100% right…

Waste of everyone time.

[EnterpriseDNA]

Hi @ysherriff, bumping this post to send bat signal to our Interns and Experts