User Profile
William_Moreno
Helper II
Joined 5 years ago
User Widgets
Contributions
Re: ABC Curve
Hi Daniel29195 thanks a lot for answer me! If it is possible, Could you develop this solution in calculate column, not as measure,. I need a static calculation, it means abc analysis has to consider (date and local) and don't change with slices. I'll be thankfull if could help me in this problem.753Views0likes1CommentABC Curve
Hi everyone, I have the spread sheet below to calculate the ABC curve, the calculation should show analyse per month and local. Could you help me? Date Local Product Qty 01/01/2023 San Diego A1 15 01/01/2023 San Diego A2 30 01/01/2023 San Diego A3 55 01/01/2023 San Diego A4 20 01/01/2023 San Diego A5 5 01/01/2023 San Diego A4 20 01/01/2023 San Diego A5 5 01/01/2023 San Diego A4 20 01/01/2023 San Diego A5 5 01/01/2023 Los Angeles A1 15 01/01/2023 Los Angeles A2 30 01/01/2023 Los Angeles A3 55 01/01/2023 Los Angeles A4 20 01/01/2023 Los Angeles A5 5 Result expected Local Product Qty % %Acumulado Curva San Diego A4 60 34% 34% A San Diego A3 55 31% 66% A San Diego A2 30 17% 83% A San Diego A5 15 9% 91% B San Diego A1 15 9% 100% C 175 Local Product Qty % %Acumulado Curva Los Angeles A3 55 44% 44% A Los Angeles A2 30 24% 68% A Los Angeles A4 20 16% 84% A Los Angeles A1 15 12% 96% C Los Angeles A5 5 4% 100% C 125Solved789Views0likes3CommentsAverage and standard deviation analysis
Hi everyone, could you help me in this situation below: tABLE 1 - dATA PRODUCT DAY DATE UNIT VALUE A 01/01/2023 KG 15.000 A 02/01/2023 KG 12.500 A 03/01/2023 KG 14.200 A 04/01/2023 KG 15.300 A 05/01/2023 KG 15.420 A 06/01/2023 KG 12.000 B 01/01/2023 KG 12.500 B 02/01/2023 KG 15.000 B 03/01/2023 KG 16.000 B 04/01/2023 KG 17.000 B 05/01/2023 KG 17.520 B 06/01/2023 KG 18.250 tABLE 2 - summary PRODUCT MONTH DATE UNIT DAILY AVERAGE DAILY STANDARD DEVIATION A jan/2023 KG 14.070 1.481 B jan/2023 KG 16.045 2.079 hOW CAN i DO IT in dax Thanks WilliamSolved652Views0likes1Commentrank in powerquery with criteria
Hi everybody, I've been facing problem to create a rank in PowerQuery (m-language) with criteria. Could you help me? Table1 Data Unit Sku Qty Rank 2021-02-01 New York 100500 100.5 2021-02-01 New York 100600 95.0 2021-02-01 New York 100700 90.0 2021-02-01 Los Angeles 100500 110.5 2021-02-01 Los Angeles 100600 100.0 2021-02-01 Los Angeles 100700 50.0 Expected table Data Unit Sku Qty Rank 2021-02-01 New York 100500 100.5 1 2021-02-01 New York 100600 95.0 2 2021-02-01 New York 100700 90.0 3 2021-02-01 Los Angeles 100500 110.5 1 2021-02-01 Los Angeles 100600 100.0 2 2021-02-01 Los Angeles 100700 50.0 3 Thanks in advanced. William M.Solved2.2KViews0likes2Commentsdifference between two rows in the power query (m-language)
Hi everyone, I need help. difference between two rows in the power query (m-language) table - 1 date unit sku value 2021-07-01 Berlim 100255 10.5 2021-07-01 Rome 100255 11.5 2021-07-01 New York 100255 12.5 2021-08-01 Berlim 100255 13.0 2021-08-01 Rome 100255 14.0 2021-08-01 New York 100255 17.0 expected results date unit sku value diference 2020-07-01 Berlim 100255 10.5 0 2020-07-01 Rome 100255 11.5 0 2020-07-01 New York 100255 12.5 0 2021-08-01 Berlim 100255 13.0 2.5 2021-08-01 Rome 100255 15.0 3.5 2021-08-01 New York 100255 18.0 5.5 Could you help? Thanks in advanced!Solved666Views0likes2Commentsdifference between two rows in the power query (m-language)
Hi everyone, Today, I have this situation "difference between two rows in the power query (m-language)" table - 1 date unit sku value 2021-07-01 Berlim 100255 10.5 2021-07-01 Rome 100255 11.5 2021-07-01 New York 100255 12.5 2021-08-01 Berlim 100255 13.0 2021-08-01 Rome 100255 14.0 2021-08-01 New York 100255 17.0 expected results date unit sku value diference 2020-07-01 Berlim 100255 10.5 0 2020-07-01 Rome 100255 11.5 0 2020-07-01 New York 100255 12.5 0 2021-08-01 Berlim 100255 13.0 2.5 2021-08-01 Rome 100255 15.0 3.5 2021-08-01 New York 100255 18.0 5.5 Could you help? Thanks in advanced! William M.Solved1.6KViews0likes1CommentBalance Inventory table
Hi everyone, I need help with this table below, I want to reproduce this in data columns and only with dax formulas, I can't use powerquery in this case. Local PartNumber Date Demand Orders Transfer Strategy Invetory OpenStock Needed Revised Need CloseStock Italy 303972 01/03/2021 0 8.000 0 9.420 0 -1.420 1.420 9.420 Italy 303972 01/04/2021 10.481 8.000 0 9.420 9.420 -2.481 2.481 9.420 Italy 303972 01/05/2021 11.126 12.000 0 9.420 9.420 0 0 10.294 Italy 303972 01/06/2021 11.490 0 0 9.420 10.294 -10.616 10.616 9.420 Italy 303972 01/07/2021 11.445 0 0 9.420 9.420 -11.445 11.445 9.420 Italy 303972 01/08/2021 11.704 0 0 9.420 9.420 -11.704 11.704 9.420 Italy 303972 01/09/2021 11.970 0 0 9.420 9.420 -11.970 11.970 9.420 Italy 303972 01/10/2021 12.126 0 0 9.420 9.420 -12.126 12.126 9.420 Italy 303972 01/11/2021 11.281 0 0 9.420 9.420 -11.281 11.281 9.420 Italy 303972 01/12/2021 11.381 0 0 9.420 9.420 -11.381 11.381 9.420 The red collors are formulas like theses: OpenStock = CloseStock month before Needed = IF(OpenStock + Orders – Demand-Transfer>Strategy,0,OpenStock + Orders – Demand-Transfer-Strategy) Revised Need = Needed x (-1) CloseStock = OpenStock + Orders – Demand-Transfer +Needed I will be very grateful if anyone can help me thanks in advanced526Views0likes1CommentCreate opening and closing stock in the data columns (trouble with circular dependecy)
Hi guys, again I need help! My problem today is about circular dependecy. I tried to build a data table for opening e closing stock, but I've had faced problems to finish it. I need to do it with columns data, at this point I didn't want to use measures. Is it possible? Table Local Code UM Data OpeningStock Sales Order Necessity ClosingStock Goal Italy PACKGING UN 01/03/2021 230.200 791.907 504.000 891.601 833.895 833.895 Italy PACKGING UN 01/04/2021 833.895 860.442 756.000 104.442 833.895 833.895 Italy PACKGING UN 01/05/2021 833.895 926.248 1.008.000 0 915.646 833.895 Italy PACKGING UN 01/06/2021 915.646 988.920 0 907.168 833.895 833.895 The column Necessity has this formula: IF(Goal - (OpenningStock + Order - Sales)<0;0;Goal - (OpenningStock + Order - Sales)) The column ClosingStock has this formula: OpeningStock + Order + Necessity - Sales Someone could help me? Thanks a lot. William M.Solved712Views0likes2Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.