Forum Discussion

jrscaletta's avatar
jrscaletta
Icon for Helper II rankHelper II
4 years ago
Solved

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's avatar
    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" 
)

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

jrscaletta 

What are you trying to calculate?

jrscaletta's avatar
jrscaletta
Icon for Helper II rankHelper II
4 years ago

Hi tamerj1!! Thanks for your reply!

I want to calculte the average date ponderated by AnimalsNum with criteria.

All my movements are on the MOVIGRANJ table (date too).

 

I have 4 important fields for this:
- DATE (Date)

- NUM ANIMALS (Integer)

- MOVEMENTTYPE (Integer)

- ARTICLETYPE -or product- (Integer)

- FARM (integer)

 

I need to calculate the average date ponderated by AnimalsNum with criteria on fields "MOVEMENTTYPE = 3" and "ARTICLETYPE = 1".

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Can you share screenshot of your source data table or provide sample data?

    • jrscaletta's avatar
      jrscaletta
      Icon for Helper II rankHelper II
      4 years ago

      Hi Tamerj1! Thanks you again, now I'm understand your budget of Community Champion 😀

       

      The file: https://we.tl/t-38IudN69ZO

       

      You can see "Fecha entrada ponderada" and "Fecha salida ponderada" is not logical result.

       

      Thanks!!!!

      • tamerj1's avatar
        tamerj1
        Icon for Community Champion rankCommunity Champion
        4 years ago

        jrscaletta 
        Apperantly this is something else. I need all the details. Please share a sample file to work with.