Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
Hi,
I've the following measure, but I'll like to know how can I change the "Consulta1[Rentabilidad] <> 0 " condition to less than -0.01 or bigger than 0.01.
Date1: =
VAR currentnemo =
MAX ( Consulta1[nemotecnico] )
VAR summarize_table =
FILTER (
SUMMARIZE ( ALL ( Consulta1 ), Consulta1[fecha], Consulta1[nemotecnico], Consulta1[Rentabilidad] ),
Consulta1[nemotecnico] = currentnemo
&& Consulta1[Rentabilidad] <> 0
)
VAR newtable =
ADDCOLUMNS (
summarize_table,
"@daterank", CALCULATE ( RANKX ( summarize_table, CALCULATE ( MAX ( Consulta1[fecha] ) ),, ASC ) )
)
VAR filternewtable =
FILTER ( newtable, [@daterank] = 1 )
RETURN
IF ( HASONEVALUE ( Consulta1[nemotecnico] ), MAXX ( filternewtable, Consulta1[fecha] ) )
Thanks!
Solved! Go to Solution.
&& Consulta1[Rentabilidad] < 0.01 || Consulta1[Rentabilidad] > 0.01
&& Consulta1[Rentabilidad] < 0.01 || Consulta1[Rentabilidad] > 0.01
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 76 | |
| 38 | |
| 31 | |
| 27 | |
| 26 |