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 guys how are you?
i'm currently working in in a car infractions report. The idea is to be able to have several indicators referring to the administration of the company car fleet. I'm using slicers, and already hace some KPIs for the accumulated, accumulated for the current year, per infraction category, top 10 users with more infractions, top 10 places where infractions are made, etc.
An infraction is always an accounting liability, could you please help me cracking some formulas. The idea is to show a trend, if the quantity or the amount in $ is increasing or decreasing against previous periods. Which formulas and KPI visualizations do you recommend?
Column TOTAL is the column where the amounts of the fines are shown, ISSUED_DATE, the date when infractions were made.
Thanks!!!
CLIENT_ID | RECORD_ID | FINE_ID | SCRAPE_DATE | PLATE_NUMBER | TOTAL | INTERESTS | LOCATION | STATUS | POINTS | REASON | ISSUED_DATE | ISSUED_HOUR | PROVINCE | DESCRIPTION | Month Name | Month | Cateoria Infracción |
DEMO | Q17526399 | 6900 | 2/7/18 17:26 | AA330OH | $ 1.300 | 0 | CHIVILCOY 1635 | 0 | Estac. lugar prohib./forma indebida/antirreglamentaria | 10 de abril de 2018 | 10:54 | CABA | T: Acta de Transito - Pago Voluntario | Abril | 4 | Estacionar Indebidamente | |
DEMO | E00184394 | 6900 | 2/7/18 17:36 | AB503WL | $ 1.300 | 0 | AV. GENERAL PAZ | 0 | Estac. lugar prohib./forma indebida/antirreglamentaria | 12 de enero de 2018 | 09:42 | CABA | T: Acta de Transito - Pago Voluntario | Enero | 1 | Estacionar Indebidamente | |
DEMO | Q16998531 | 6900 | 2/7/18 17:36 | AB503WL | $ 1.300 | 0 | TUYUTI 7252 | 0 | Estac. lugar prohib./forma indebida/antirreglamentaria | 16 de enero de 2018 | 08:01 | CABA | T: Acta de Transito - Pago Voluntario | Enero | 1 | Estacionar Indebidamente | |
DEMO | Q17109346 | 6900 | 2/7/18 17:36 | AB503WL | $ 1.300 | 0 | CARRERAS, SEGUNDO IÑIGO 7245 | 0 | Estac. lugar prohib./forma indebida/antirreglamentaria | 23 de enero de 2018 | 08:03 | CABA | T: Acta de Transito - Pago Voluntario | Enero | 1 | Estacionar Indebidamente | |
DEMO | E00018945 | 6900 | 2/7/18 17:46 | ANW444 | $ 1.300 | 0 | FERRE 3100 | 0 | Estac. lugar prohib./forma indebida/antirreglamentaria | 26 de octubre de 2017 | 10:38 | CABA | T: Acta de Transito - Pago Voluntario | Octubre | 10 | Estacionar Indebidamente | |
DEMO | E00186189 | 6900 | 2/7/18 17:46 | ANW444 | $ 1.300 | 0 | FERRE 2100 | 0 | Estac. lugar prohib./forma indebida/antirreglamentaria | 12 de enero de 2018 | 11:20 | CABA | T: Acta de Transito - Pago Voluntario | Enero | 1 | Estacionar Indebidamente | |
DEMO | B16151563 | 6900 | 2/7/18 17:47 | AQB348 | $ 1.300 | 0 | PARAGUAY 2300 | 0 | Estac. lugar prohib./forma indebida/antirreglamentaria | 17 de julio de 2015 | 12:08 | CABA | T: Acta de Transito - Pago Voluntario | Julio | 7 | Estacionar Indebidamente | |
DEMO | B16504442 | 6900 | 2/7/18 17:47 | AQB348 | $ 1.300 | 0 | BOLIVAR | 0 | Estac. lugar prohib./forma indebida/antirreglamentaria | 11 de octubre de 2016 | 17:03 | CABA | T: Acta de Transito - Pago Voluntario | Octubre | 10 | Estacionar Indebidamente | |
DEMO | C00327819 | 6900 | 2/7/18 17:47 | AQB348 | $ 1.300 | 0 | LA RIOJA 1286 | 0 | Estac. lugar prohib./forma indebida/antirreglamentaria | 4 de noviembre de 2015 | 13:40 | CABA | T: Acta de Transito - Pago Voluntario | Noviembre | 11 | Estacionar Indebidamente | |
DEMO | Q17479943 | 6900 | 2/7/18 17:47 | AQB348 | $ 1.300 | 0 | SAN JUAN AV. 3001 | 0 | Estac. lugar prohib./forma indebida/antirreglamentaria | 15 de marzo de 2018 | 10:19 | CABA | T: Acta de Transito - Pago Voluntario | Marzo | 3 | Estacionar Indebidamente | |
DEMO | E00366229 | 6900 | 2/7/18 17:50 | BEQ469 | $ 1.300 | 0 | AV. ESPAÑA 2053 | 0 | Estac. lugar prohib./forma indebida/antirreglamentaria | 19 de abril de 2018 | 13:01 | CABA | T: Acta de Transito - Pago Voluntario | Abril | 4 | Estacionar Indebidamente | |
DEMO | B15831233 | 6900 | 2/7/18 17:52 | BMR903 | $ 1.300 | 0 | PTE ROQUE SAENZ PEÑA, AV. 530 | 0 | Estac. lugar prohib./forma indebida/antirreglamentaria | 12 de noviembre de 2014 | 10:00 | CABA | T: Acta de Transito - Pago Voluntario | Noviembre | 11 | Estacionar Indebidamente | |
DEMO | B16028290 | 6900 | 2/7/18 17:53 | BPZ307 | $ 1.300 | 0 | MANUEL GARCIA 347 | 0 | Estac. lugar prohib./forma indebida/antirreglamentaria | 24 de abril de 2015 | 10:24 | CABA | T: Acta de Transito - Pago Voluntario | Abril | 4 | Estacionar Indebidamente |
Solved! Go to Solution.
Hi @franorio,
Please try out the demo in the attachment that is based your descriptions here. If you need some adjustments, please provide more details.
1. A date table is needed.
2. Create a measure which will compare this month to last month.
Measure = SUM ( Table1[TOTAL] ) - CALCULATE ( SUM ( Table1[TOTAL] ), PREVIOUSMONTH ( 'Calendar'[Date] ) )
Best Regards,
Dale
Hi @franorio,
Could you mark the proper answer as a solution, please?
Best Regards,
Dale
Hi @franorio,
Please try out the demo in the attachment that is based your descriptions here. If you need some adjustments, please provide more details.
1. A date table is needed.
2. Create a measure which will compare this month to last month.
Measure = SUM ( Table1[TOTAL] ) - CALCULATE ( SUM ( Table1[TOTAL] ), PREVIOUSMONTH ( 'Calendar'[Date] ) )
Best Regards,
Dale
User | Count |
---|---|
83 | |
77 | |
70 | |
69 | |
54 |
User | Count |
---|---|
106 | |
96 | |
90 | |
79 | |
68 |