topic Re: Comparing TEXT vs INT not allowed.. but I'm using FORMAT!! in DAX Commands and Tips

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

jrscaletta — Thu, 05 May 2022 09:53:43 GMT

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 advance

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

tamerj1 — Thu, 05 May 2022 10:31:25 GMT

Hi jrscaletta
A small mistake

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

jrscaletta — Thu, 05 May 2022 10:38:52 GMT

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

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

tamerj1 — Thu, 05 May 2022 10:50:41 GMT

jrscaletta

What are you trying to calculate?

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

jrscaletta — Thu, 05 May 2022 10:56:30 GMT

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

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

tamerj1 — Thu, 05 May 2022 11:05:00 GMT

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

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

jrscaletta — Thu, 05 May 2022 11:11:44 GMT

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!!!!

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

tamerj1 — Thu, 05 May 2022 11:40:35 GMT

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

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

jrscaletta — Thu, 05 May 2022 11:59:57 GMT

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!!

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

tamerj1 — Thu, 05 May 2022 12:24:23 GMT

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

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

jrscaletta — Thu, 05 May 2022 12:29:22 GMT

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