Join 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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi guys, i have a table wiht this columns:
Fecha | Atrasos2 | Atrasos3 | Capital_MN |
30/9/2018 | 5 | 5 | 478 |
31/10/2019 | 40 | 40 | 9821 |
30/11/2019 | 56 | 56 | 8425 |
31/12/2019 | 87 | 87 | 478 |
31/1/2020 | 10 | 0 | 1000 |
28/2/2020 | 50 | 0 | 2000 |
31/3/2020 | 1 | 0 | 50 |
28/4/2020 | 12 | 0 | 700 |
31/10/2020 | 2 | 0 | 800 |
30/11/2020 | 1 | 0 | 1550 |
31/1/2021 | 10 | 0 | 1205 |
28/2/2021 | 600 | 600 | 200 |
30/4/2021 | 20 | 20 | 355 |
Atrasos2: They are the days behind without taking into account the covid issue.
Atrasos3: It is a calculated column where if the dates are between 31/01/2020 and 31/01/2021 (covid issue), the days of arrears are zeroed.
I also have this measure:
Solved! Go to Solution.
@ArquimedesP
Use the measure given below:
SUMAPRODUCTO CARTERA =
VAR __V =
SELECTEDVALUE ( Table[VAlue], "Normal" )
RETURN
DIVIDE (
SUMX (
VW_Cartera,
IF (
__v = "Covid",
VW_Cartera[Atrasos3] * VW_Cartera[Capital_MN],
VW_Cartera[Atrasos2] * VW_Cartera[Capital_MN]
)
),
SUM ( VW_Cartera[Capital_MN] )
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
it worked perfectly! Thanks a lot!
@ArquimedesP
Use the measure given below:
SUMAPRODUCTO CARTERA =
VAR __V =
SELECTEDVALUE ( Table[VAlue], "Normal" )
RETURN
DIVIDE (
SUMX (
VW_Cartera,
IF (
__v = "Covid",
VW_Cartera[Atrasos3] * VW_Cartera[Capital_MN],
VW_Cartera[Atrasos2] * VW_Cartera[Capital_MN]
)
),
SUM ( VW_Cartera[Capital_MN] )
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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 |
---|---|
12 | |
11 | |
9 | |
9 | |
8 |