Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
Solved! Go to Solution.
@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"
)
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
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".
Can you share screenshot of your source data table or provide sample data?
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!!!!
@jrscaletta
Apperantly this is something else. I need all the details. Please share a sample file to work with.
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!!
@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"
)
It works!!! Thanks you so much for your help!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
14 | |
11 | |
7 |
User | Count |
---|---|
25 | |
24 | |
12 | |
12 | |
11 |