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.
Hi,
I have situation when i need calculate debt in delayed days in ranges like 1-30 days, 31-60 days and more. my measure:
Filtered measure_t5 =
SUMX (
FILTER (
VALUES ( I44_SKOL[I44_DOK_NR] ),
[20_2_1_DATA PRADELSIMAS] > 360
),
CALCULATE ( [18_1_0_BENDRA SKOLA (nuo istorijos pradzios)] )
)
data_pradelsimas is days overdue
bendra_skola is debt.
So how fix my measure?
Hi @Analitika
Assume that [20_2_1_DATA PRADELSIMAS] and [18_1_0_BENDRA SKOLA (nuo istorijos pradzios)] are both measures, you can try below measure
Filtered measure_t5 =
VAR _table =
SUMMARIZE (
I44_SKOL[I44_DOK_NR],
"data_pradelsimas", [20_2_1_DATA PRADELSIMAS]
)
RETURN
SUMX (
FILTER ( _table, [data_pradelsimas] > 360 ),
[18_1_0_BENDRA SKOLA (nuo istorijos pradzios)]
)
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |