Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hola a todos. Agradezco cualquier ayuda que me proporcionen.
Tengo 2 tablas: uf_prosp y TBL_CCS_DAP_Test
Las 2 se relacionan con un campo fecha_proceso (31/12/2021 y 31/01/2022) y plazo_residual (número de días)
Esta medida obtiene los valores de esc_1 para el plazo_residual interpolando con los datos de las columnas _plazo y esc_1 de la tabla uf_prosp
Solved! Go to Solution.
Hi! You can use logic like this:
VAR CurrentRow = MAX('Calendar'[WEEKINT])
VAR ProductionLW1 = CALCULATE([Value],FILTER(ALL('Calendar'), 'Calendar'[WEEKINT] = CurrentRow - 1))
VAR ProductionLW2 = CALCULATE([Value],FILTER(ALL('Calendar'), 'Calendar'[WEEKINT] = CurrentRow - 2))
Hi! You can use logic like this:
VAR CurrentRow = MAX('Calendar'[WEEKINT])
VAR ProductionLW1 = CALCULATE([Value],FILTER(ALL('Calendar'), 'Calendar'[WEEKINT] = CurrentRow - 1))
VAR ProductionLW2 = CALCULATE([Value],FILTER(ALL('Calendar'), 'Calendar'[WEEKINT] = CurrentRow - 2))
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |