Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hola, solicitando de su apoyo...tengo esta formula en excel en la columna:
Por Vencer : =SI(Y(X8778="",Q8778<=Tabla!$F$1),"7 días",SI(Y(X8778="",Q8778<=Tabla!$G$1),"14 días",SI(Y(X8778="",Q8778<=Tabla!$H$1),"21 días",SI(Y(X8778="",Q8778<=Tabla!$I$1),"30 días",SI(X8778="Past Due","Past Due","+30 DÍAS")))))
Tengo esto datos de donde se toma la información para la formula:
Tabla
He tratado pero no logro replicarla en power bi
Solved! Go to Solution.
HI @jalopez,
It seems like a common if statement expression to check conditions and return different segment flags.
Since power bi does not include row and column index, I think you need to add index fields to that table if your formula required to look up specific cell values.
Add an index column - Power Query | Microsoft Learn
BTW, please also convert these parameter fields to a table with different groups or indexes, then you can use the formula to look up them as conditions. (para table: group, date)
Sample calculate column formula:
Por Vencer =
IF (
AND (
Table[Past Due] = "",
Table[Ship Date] <= LOOKUPVALUE ( ParaTable[Date], ParaTable[Group], "F" )
),
"7 días",
IF (
AND (
Table[Past Due] = "",
Table[Ship Date] <= LOOKUPVALUE ( ParaTable[Date], ParaTable[Group], "G" )
),
"14 días",
IF (
AND (
Table[Past Due] = "",
Table[Ship Date] <= LOOKUPVALUE ( ParaTable[Date], ParaTable[Group], "H" )
),
"21 días",
IF (
AND (
Table[Past Due] = "",
Table[Ship Date] <= LOOKUPVALUE ( ParaTable[Date], ParaTable[Group], "I" )
),
"30 días",
IF ( Table[Past Due] = "Past Due", "Past Due", "+30 DÍAS" )
)
)
)
)
LOOKUPVALUE function (DAX) - DAX | Microsoft Learn
Regards,
Xiaoxin Sheng
HI @jalopez,
It seems like a common if statement expression to check conditions and return different segment flags.
Since power bi does not include row and column index, I think you need to add index fields to that table if your formula required to look up specific cell values.
Add an index column - Power Query | Microsoft Learn
BTW, please also convert these parameter fields to a table with different groups or indexes, then you can use the formula to look up them as conditions. (para table: group, date)
Sample calculate column formula:
Por Vencer =
IF (
AND (
Table[Past Due] = "",
Table[Ship Date] <= LOOKUPVALUE ( ParaTable[Date], ParaTable[Group], "F" )
),
"7 días",
IF (
AND (
Table[Past Due] = "",
Table[Ship Date] <= LOOKUPVALUE ( ParaTable[Date], ParaTable[Group], "G" )
),
"14 días",
IF (
AND (
Table[Past Due] = "",
Table[Ship Date] <= LOOKUPVALUE ( ParaTable[Date], ParaTable[Group], "H" )
),
"21 días",
IF (
AND (
Table[Past Due] = "",
Table[Ship Date] <= LOOKUPVALUE ( ParaTable[Date], ParaTable[Group], "I" )
),
"30 días",
IF ( Table[Past Due] = "Past Due", "Past Due", "+30 DÍAS" )
)
)
)
)
LOOKUPVALUE function (DAX) - DAX | Microsoft Learn
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
56 | |
27 | |
24 | |
14 | |
9 |
User | Count |
---|---|
77 | |
61 | |
47 | |
17 | |
12 |