cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper II

## 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")``````

1 ACCEPTED SOLUTION
Super User

@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"
)``````

10 REPLIES 10
Helper II

Thnanks you very much! Now it works, but the result isn't correct, I obtain date "10/8/2143", when my most recent date is "02/05/2022"...

Ideas? Thanks

Super User

What are you trying to calculate?

Helper II

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".

Super User

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

Helper II

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

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

Thanks!!!!

Super User

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

Helper II

Hi Tamerj

I attach basic and easy compensive sample file. Thanks! Download file (By Wetransfer): https://we.tl/t-0NhKxNu8Ql

As you can see, the weighted average date is not correct. It shows 2045 year!! My data is all 2022.

Thanks!!

Super User

@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"
)``````

Helper II

It works!!! Thanks you so much for your help!

Super User

Hi @jrscaletta
A small mistake