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: Weigh...

help measure comparative

tamerj1

4 years ago

jrscaletta
You can use

Weighted Averaged Date Movement type 1 = 
FORMAT (
    SUMX (
        FILTER ( Hoja1, Hoja1[MovementType] = 1 && Hoja1[ArticleType] = 1 ),
        Hoja1[Date] * Hoja1[AnimalsNumber]
    ) / [AnimalsMovementType1],
    "General Date" 
)

Forum Discussion

Comparing TEXT vs INT not allowed.. but I'm using FORMAT!!

Related content

Conditional formating - comparing day to day

Table Sort , sort order , comparer

Conditional Formatting

Matrix formatting

Condition formatting