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.
hello everyone , i need help with this, i am new in this
i need next row - row
i have this but is wrong
Solved! Go to Solution.
@Anonymous ,Try as New columns
next date = Minx(filter('ENE 2020',[DETALLE MAQUINARIA] = EARLIER ([DETALLE MAQUINARIA] ) && [FECHA] > EARLIER ([FECHA] ) ), [FECHA])
next Value = Minx(filter('ENE 2020',[DETALLE MAQUINARIA] = EARLIER ([DETALLE MAQUINARIA] ) && [FECHA] =EARLIER ([next date] ) ), [HOROM])
@Anonymous ,Try as New columns
next date = Minx(filter('ENE 2020',[DETALLE MAQUINARIA] = EARLIER ([DETALLE MAQUINARIA] ) && [FECHA] > EARLIER ([FECHA] ) ), [FECHA])
next Value = Minx(filter('ENE 2020',[DETALLE MAQUINARIA] = EARLIER ([DETALLE MAQUINARIA] ) && [FECHA] =EARLIER ([next date] ) ), [HOROM])
Hi,
If the numbers i the third column are always in ascending order (as is the case in your example), then try this calculated column formula
=Calculate(min('ENE 2020'[HORÓM.]),filter('ENE 2020','ENE 2020'[DETALLE MAQUINARIA]=earlier('ENE 2020'[DETALLE MAQUINARIA])))-'ENE 2020'[HORÓM.]
Hope this helps.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
93 | |
87 | |
80 | |
69 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |