help measure comparative
1 Topic
Comparing TEXT vs INT not allowed.. but I'm using FORMAT!!
Hi!! obtain an error comparing "TEXT" vs "INT", but I'm using FORMAT too, I don't understand. I want this measure returns weighted average by date,,, ideas? Thanks you! My measure is: Weighted Average by Date = FORMAT( SUMX( FILTER(MOVIGRANJ, MOVIGRANJ[MovementType] = 3 & MOVIGRANJ[ArticleType] = 1), MOVIGRANJ[Date].[Date]*MOVIGRANJ[AnimalsNumber]/MOVIGRANJ[AnimalsNumber]), "General Date") Thanks in advanceSolved2.1KViews0likes10Comments