March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
26 | |
16 | |
15 | |
12 | |
11 |
User | Count |
---|---|
32 | |
26 | |
24 | |
18 | |
14 |