Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hola a todos
He creado una medida utilizando variables para el cálculo dinámico. Probé la misma fórmula para la columna calculada, pero da espacios en blanco.
Quiero buscar la columna en una tabla anlother, así que estoy convirtiendo la medida en columna usando la fórmula Columna ,[Medida],
pero está dando valores en blanco para algunas filas.
La medida muestra los valores correctos en el objeto visual de la matriz, pero al convertirlo en columna, los datos cambian.
a continuación se muestra la medida cuando se arrastra a visual.
superiores son valores correctos.
pero al convertir a columna:-
¿Por qué los valores se muestran como cero, donde como en visual muestran el valor correcto.
¿Hay algo que pueda hacer, esta columna es muy importante ya que todos los demás cálculos se basan en esta columna.
a continuación está mi cálculo de medida, está tomando todas las entradas como variables para 12 meses dinámicos anteriores.
DOS á //No de los días de cada mes var nod-CALCULATE(SUM('New Table'[No of days]),DATESINPERIOD('New Table'[TDate],MAX('New Table'[TDate]),-1,MONTH)) var pr_nod-CALCULATE(SUM('New Table'[No of days]),PREVIOUSMONTH('New Table'[TDate])) var pr_nod2-CALCULATE(SUM('New Table'[No of days]),DATEADD('New Table'[TDate],-2,MONTH)) var pr_nod3-CALCULATE(SUM('New Table'[No of days]),DATEADD('New Table'[TDate],-3,MONTH)) var pr_nod4-CALCULATE(SUM('New Table'[No of days]),DATEADD('New Table'[TDate],-4,MONTH)) var pr_nod5-CALCULATE(SUM('New Table'[No of days]),DATEADD('New Table'[TDate],-5,MONTH)) var pr_nod6-CALCULATE(SUM('New Table'[No of days]),DATEADD('New Table'[TDate],-6,MONTH)) var pr_nod7-CALCULATE(SUM('New Table'[No of days]),DATEADD('New Table'[TDate],-7,MONTH)) var pr_nod8-CALCULATE(SUM('New Table'[No of days]),DATEADD('New Table'[TDate],-8,MONTH)) var pr_nod9-CALCULATE(SUM('New Table'[No of days]),DATEADD('New Table'[TDate],-9,MONTH)) var pr_nod10-CALCULATE(SUM('New Table'[No of days]),DATEADD('New Table'[TDate],-10,MONTH)) var pr_nod11-CALCULATE(SUM('New Table'[No of days]),DATEADD('New Table'[TDate],-11,MONTH)) var pr_nod12-CALCULATE(SUM('New Table'[No of days]),DATEADD('New Table'[TDate],-12,MONTH)) Suma de meses anteriores Peso var pr_mnth-CALCULATE(SUM('New Table'[TotalWeight]),PREVIOUSMONTH('New Table'[TDate])) var pr_mnth2-CALCULATE(SUM('New Table'[TotalWeight]),DATEADD('New Table'[TDate],-2,MONTH)) var pr_mnth3-CALCULATE(SUM('New Table'[TotalWeight]),DATEADD('New Table'[TDate],-3,MONTH)) var pr_mnth4-CALCULATE(SUM('New Table'[TotalWeight]),DATEADD('New Table'[TDate],-4,MONTH)) var pr_mnth5-CALCULATE(SUM('New Table'[TotalWeight]),DATEADD('New Table'[TDate],-5,MONTH)) var pr_mnth6-CALCULATE(SUM('New Table'[TotalWeight]),DATEADD('New Table'[TDate],-6,MONTH)) var pr_mnth7-CALCULATE(SUM('New Table'[TotalWeight]),DATEADD('New Table'[TDate],-7,MONTH)) var pr_mnth8-CALCULATE(SUM('New Table'[TotalWeight]),DATEADD('New Table'[TDate],-8,MONTH)) var pr_mnth9-CALCULATE(SUM('New Table'[TotalWeight]),DATEADD('New Table'[TDate],-9,MONTH)) var pr_mnth10-CALCULATE(SUM('New Table'[TotalWeight]),DATEADD('New Table'[TDate],-10,MONTH)) var pr_mnth11-CALCULATE(SUM('New Table'[TotalWeight]),DATEADD('New Table'[TDate],-11,MONTH)) Suma rodante de meses var cmnth-CALCULATE(SUM('New Table'[TotalWeight]),DATESINPERIOD('New Table'[TDate],MAX('New Table'[TDate]),-1,MONTH)) var mnth_2-CALCULATE(SUM('New Table'[TotalWeight]),DATESINPERIOD('New Table'[TDate],MAX('New Table'[TDate]),-2,MONTH)) var mnth_3-CALCULATE(SUM('New Table'[TotalWeight]),DATESINPERIOD('New Table'[TDate],MAX('New Table'[TDate]),-3,MONTH)) var mnth_4-CALCULATE(SUM('New Table'[TotalWeight]),DATESINPERIOD('New Table'[TDate],MAX('New Table'[TDate]),-4,MONTH)) var mnth_5-CALCULATE(SUM('New Table'[TotalWeight]),DATESINPERIOD('New Table'[TDate],MAX('New Table'[TDate]),-5,MONTH)) var mnth_6-CALCULATE(SUM('New Table'[TotalWeight]),DATESINPERIOD('New Table'[TDate],MAX('New Table'[TDate]),-6,MONTH)) var mnth_7-CALCULATE(SUM('New Table'[TotalWeight]),DATESINPERIOD('New Table'[TDate],MAX('New Table'[TDate]),-7,MONTH)) var mnth_8-CALCULATE(SUM('New Table'[TotalWeight]),DATESINPERIOD('New Table'[TDate],MAX('New Table'[TDate]),-8,MONTH)) var mnth_9-CALCULATE(SUM('New Table'[TotalWeight]),DATESINPERIOD('New Table'[TDate],MAX('New Table'[TDate]),-9,MONTH)) var mnth_10-CALCULATE(SUM('New Table'[TotalWeight]),DATESINPERIOD('New Table'[TDate],MAX('New Table'[TDate]),-10,MONTH)) var mnth_11-CALCULATE(SUM('New Table'[TotalWeight]),DATESINPERIOD('New Table'[TDate],MAX('New Table'[TDate]),-11,MONTH)) var mnth_12-CALCULATE(SUM('New Table'[TotalWeight]),DATESINPERIOD('New Table'[TDate],MAX('New Table'[TDate]),-12,MONTH)) var calc- IFERROR(IF([Inv]<-cmnth,[Inv]/cmnth*nod,IF([Inv]<-mnth_2,([Inv]-cmnth)/pr_mnth*pr_nod+nod,IF([Inv]<-mnth_3,([Inv]-cmnth-pr_mnth)/pr_mnth2*pr_nod2+pr_nod+nod,IF([Inv]<-mnth_4,([Inv]-cmnth-pr_mnth-pr_mnth2)/pr_mnth3*pr_nod3+pr_nod2+pr_nod+nod, if([Inv]<-mnth_5,([Inv]-cmnth-pr_mnth-pr_mnth2-pr_mnth3)/pr_mnth4*pr_nod4+pr_nod3+pr_nod2+pr_nod+nod,if([Inv]<-mnth_6,([[[[pr_nod3+pr_nod2+pr_nod+nod,if([Inv]<-mnth_6,([[[[[[pr_nod2+pr_nod2+pr_nod+nod,if([Inv]<-mnth_6,([[[[[[[pr_nod2+pr_nod+nod,if([Inv]<-mnth_6,([[[[[[[pr_nod2+pr_nod+nod,if([Inv]<-mnth_6,([[[[[[[[Inv]-cmnth-pr_mnth-pr_mnth2-pr_mnth3-pr_mnth4)/pr_mnth5*pr_nod5+pr_nod4+pr_nod3+pr_nod2+pr_nod+nod,if([Inv]<-mnth_7,([Inv]-cmnth -pr_mnth-pr_mnth2-pr_mnth3-pr_mnth4-pr_mnth5)/pr_mnth6*pr_nod6+pr_nod5+pr_nod4+pr_nod3+pr_nod2+pr_nod+nod,if([Inv]<-mnth_8,([Inv]-cmnth-pr_mnth-pr_mnth2-pr_mnth3-pr_mnth4-pr_mnth5-pr_mnth6)/pr_mnth7*pr_nod7+pr_nod6+pr_nod5+pr_nod4+pr_nod3+pr_nod2+pr_nod+pr_nod+nod, if([Inv]<=mnth_9,([Inv]-cmnth-pr_mnth-pr_mnth2-pr_mnth3-pr_mnth4-pr_mnth5-pr_mnth6-pr_mnth7)/pr_mnth8*pr_nod8+pr_nod7+pr_nod6+pr_nod5+pr_nod4+pr_nod3+pr_nod2+pr_nod+nod,if([Inv]<=mnth_10,([Inv]-cmnth-pr_mnth-pr_mnth2-pr_mnth3-pr_mnth4-pr_mnth5-pr_mnth6-pr_mnth7-pr_mnth8)/pr_mnth9*pr_nod9+pr_nod8+pr_nod7+pr_nod6+pr_nod5+pr_nod4+pr_nod3+pr_nod2+pr_nod+nod,if([Inv]<=mnth_11,([Inv]-cmnth-pr_mnth-pr_mnth2-pr_mnth3-pr_mnth4-pr_mnth5-pr_mnth6-pr_mnth7-pr_mnth8-pr_mnth9)/pr_mnth10*pr_nod10+pr_nod9+pr_nod8+pr_nod7+pr_nod6+pr_nod5+pr_nod4+pr_nod3+pr_nod2+pr_nod+nod,if([Inv]<=mnth_12,([Inv]-cmnth-pr_mnth-pr_mnth2-pr_mnth3-pr_mnth4-pr_mnth5-pr_mnth6-pr_mnth7-pr_mnth8-pr_mnth9-pr_mnth10)/pr_mnth11*pr_nod11+pr_nod10+pr_nod9+pr_nod8+pr_nod7+pr_nod6+pr_nod5+pr_nod4+pr_nod3+pr_nod2+pr_nod+nod)))))))))))) ,0) retorno calc |
@Ayesha28 será mucho más fácil si comparte datos de muestra con el resultado esperado que está buscando. Lee este post para obtener tu respuesta rápidamente.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hola @parry2k ,
Por favor, encuentre el siguiente enlace a mi archivo pbix, tiene la medida creada para los días de suministro llamado medida.
básicamente compara inv con sumas de peso rodantes. Lo necesito en una columna para poder buscarlo en otra mesa.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
2 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
2 | |
2 | |
2 | |
2 | |
1 |