Skip to content
ACD-320 · ingestia.biPreview

pt-BR formulas: from SOMA to CALCULAR

Course ACD-320 of the Ingestia Academy — 13 lessons, 6.5 h of work.

Level
Intermediate to advanced
Estimated load
6,5 h of dedication
Video
13 lessons · 11 min of video

Lessons

  1. `;` and the decimal comma, `VAR/RETORNAR`, honest blanksRecognize the syntax and what differs from DAX6 minOperatePreviewvideo in production
  2. SOMA, MEDIA, CONT, CONTD, MIN/MAX, MEDIANACreate Receita, Pedidos, Ticket médio7 minOperatePreviewvideo in production
  3. SE, E/OU, SEERRO, COALESCE, EHVAZIO, ESCOLHERHandle blank and error without inventing zero7 minOperatePreviewvideo in production
  4. TEXTO, VALOR, CONCATENAR, ESQUERDA/DIREITA, ARRED, DIVIDIRFormat labels; divide without an error6 minOperatePreviewvideo in production
  5. Row context × filter contextPredict the value in every cell of the visual8 minOperatePreviewvideo in production
  6. CALCULAR with TUDO, FILTRAR, TUDO_EXCETO, REMOVER_FILTROS, MANTER_FILTROSCompose share of total and a fixed slice10 minOperatePreviewvideo in production
  7. SOMAX, MEDIAX, CONTX, JUNTARX, MAXX/MINXCalculate row by row (margin per item)8 minOperatePreviewvideo in production
  8. ACUM_ANO/TRI/MES, PRIMEIRA/ULTIMA_DATA, INICIO/FIM_*Create YTD/MTD over a fiscal calendar8 minOperatePreviewvideo in production
  9. MESMO_PERIODO_ANO_ANTERIOR, MES_ANTERIOR, DESLOCAR_PERIODO, PERIODO_PARALELO, DATAS_NO_PERIODOCompare periods; 12-month moving average9 minOperatePreviewvideo in production
  10. SALDO_INICIAL / SALDO_FINALTell a balance from a sum6 minOperatePreviewvideo in production
  11. PCT_TOTAL, ACUMULADO, CLASSIFICAR, PRIMEIROS_N, PROCV, TRATAR_COMOBuild a ranking, a top N and an ABC curve9 minOperatePreviewvideo in production
  12. KPIs/targets, calculation groups, what-if, dynamic formatCreate a KPI with a target and an "Atual/YTD/AA" group8 minOperatePreviewvideo in production
  13. Coming from DAX: what differs; assisted importerConvert 5 DAX measures; identify what does not convert7 minOperatePreviewvideo in production

How this course is graded#

Every lesson has a quick check (2 to 3 questions, graded on the server). The course counts as completed when every lesson is completed. The credentials this course feeds require, besides the courses, the exam and the hands-on challenge described on the certification page.