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.
I want to add the values in the C1 column according to their respective StockItemNames and put those values in another column C2. I attaching some photos which show an example of I want the final output. Please help me with this DAX.
Solved! Go to Solution.
@Harshwardhan - You will need to have something in your data that defines "previous". See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395...
@Harshwardhan , to get C2, you need an index or some date column
https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi
Try a new column
sumx(filter(Table, [stockitemname] = earlier([stockitemname]) && [index] <= earlier([index])),[C1])
@Harshwardhan , to get C2, you need an index or some date column
https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi
Try a new column
sumx(filter(Table, [stockitemname] = earlier([stockitemname]) && [index] <= earlier([index])),[C1])
@Harshwardhan - You will need to have something in your data that defines "previous". See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395...
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 |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |