Calculate products used on a daily basis
Hello Everyone, I have a simple table that has Quantity and Stock. The goal is to know how many products are being consumed on a daily basis. Here is the sample data table and desired result. Wondering how I can execute the desired result into a measure or calculated column using DAX or Power Query perhaps. Essentially this is how it was being computed in Excel. And below is the result it was giving. LOB Warehouse Product Date Quantity Stock Result A Target ABD-1155124 13/04/2023 3 11 8 B Target ABD-1155124 27/01/2023 1 11 7 B Target ABD-1155124 05/04/2023 1 11 6 B Target ABD-1155124 11/04/2023 1 11 5 B Target ABD-1155124 27/04/2023 1 11 4 B Target ABD-1155124 22/05/2023 1 11 3 B Target ABD-1155124 19/06/2023 1 11 2 B Target ABD-1155124 04/07/2023 1 11 1 B Target ABD-1155124 19/07/2023 1 11 0 B Target ABD-1155124 20/07/2023 1 11 -1 B Target ABD-1155124 01/08/2023 1 11 -2How to progressively count values in a column
Hi All After some help with the sample data i have below, i have a column called Reference and want to add a new column which counts how many occurences cumulatively within the data, for example '1472321-2860846' shows up 3 times in the reference column so what i would like is for Power Bi to show that it occurs 3 times but show the 1st instance, 2nd Instance and 3rd Instance if that makes sense, have done a bit of googling and searching this forum but so far havent found a solution Hoping this communintiy can help Thanks in advanced Ash
Medida incremental a partir de otra medida
Hola, tengo un problema con una medida acumulativa que no me acumula según requerimiento. He leído el foro y no hay nada similar. Mi problema es que necesito que sesiones agg, sea incremental taa = VAR vTableID = SUMMARIZE( Sesiones, Sesiones[LApp], Sesiones[timestamp.1], Sesiones[session_Id], "Rank", RANKX(ALL(Sesiones), Sesiones[N Sesiones]) ) VAR vTableWithMeasure = ADDCOLUMNS ( vTableID, "Sesiones Agg", Sesiones[N Sesiones] ) return vTableWithMeasure Añado unos datos que tengo de ejemplo
cumulatives percentages
Hello, I have an excel file with two columns Items and Number, I created a measure to have the item by category as a percentage based on the purchase of each customer. I would like to add an additional column to calculate cumulatives of the percentage but I don't know how to proceed, I want to use Dax formula But I only find formula, where a column is a Number , while my data are string Thank you in advance for your help. best Regards,
