User Profile
arcejames
Frequent Visitor
Joined 7 years ago
User Widgets
Contributions
Re: Last refresh time not correct between data set and report, both in the service
try this function in Power Query / Blank query : DateTimeZone.SwitchZone(DateTimeZone.LocalNow(),-6,0) and then convert that column to Table. The variable -6 can be changed based on the prefered Time Zone. and let me know if that worksGran Total de Medidas
He creado una medida que multiplica TotEndingInventory (deseo es una medida) por TotStCost (que también es una medida) Pero, cuando pongo esa medida en una tabla, el total general está realizando su función original (es decir, TotEndingInventory * TotStandarCost en lugar de resumir los valores de fila de los individuos. Según la captura de pantalla siguiente, el total de la columna TotEndingInventoryVal es 5.5, que es el resultado de TotEndingIventory * TotStCost, en lugar de 2.7, que es la SUMA de los valores de fila en esta columna... la fórmula propuesta a continuación no está funcionando Tot$FrcstInv á IF(HASONEVALUE(ItemList[SAPMaterial]),[TotEndingInvVal],SUMX(SUMMARIZE(VALUES(ITEMList[SAPMaterial]),ItemList[SAPMaterial],"Total",[TotEndingInvVal]),[Total]))Grand Total of Measures
I've created a measure that multiplies TotEndingInventory (wish is a meassure) by TotStCost ( which is a measure as well) But, when I put that measure in a table, the grand total is performing its original function (that is TotEndingInventory * TotStandarCost instead of summarizing the individuals row values. According with the screenshot below, the total of TotEndingInventoryVal column is 5.5, which is the result of TotEndingIventory * TotStCost, instead of 2.7, which is the SUM of the row values in this column... the proposed formula below is not working Tot$FrcstInv = IF(HASONEVALUE(ItemList[SAPMaterial]),[TotEndingInvVal],SUMX(SUMMARIZE(VALUES(ItemList[SAPMaterial]),ItemList[SAPMaterial],"Total",[TotEndingInvVal]),[Total]))Grand Total of Measures did not match with SUM of row values
Hello, I've created a measure that multiplies TotEndingInventory (wish is a meassure) by TotStCost ( which is a measure as well) But, when I put that measure in a table, the grand total is performing its original function (that is TotEndingInventory * TotStandarCost instead of summarizing the individuals row values. According with the screenshot below, the total of TotEndingInventoryVal column is $211 437, which is the result of TotEndingIventory * TotStCost, instead of $72 945, which is the SUM of the row values in this column... Can anybody help me please? Tks in advance.
