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

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors