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 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 |
|---|---|
| 8 | |
| 6 | |
| 3 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 11 | |
| 9 | |
| 8 | |
| 7 | |
| 6 |