Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
65 | |
60 | |
56 |
User | Count |
---|---|
183 | |
111 | |
105 | |
77 | |
70 |