Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello everybody,
I am new to the community and to Power BI itself, I have been looking for an answer on the already posted questions but I haven't found a solution to my needs.
In my organization we receive a monthly forecast file (units) of what is going to be ordered to our main warehouse. We have then forecast set 01/01/2021, 01/02/2022 an so on.
I am now working on analysing this data and its accuracy vs the actual sales (or issues from the warehouse in units).
My issue at the moment is I am not able to show in Power BI the correct units I have in my source file, as for one Forecast Set (month in which I receive the forecast) there might be more than one Forecast Date (month in which the units are going to be ordered).
Source file:
Material | Forecast Date | Forecasted Units | Forecast Set |
40163 | 01/04/2021 | 350 | 01/04/2021 |
40163 | 01/06/2021 | 50 | 01/06/2021 |
40163 | 01/04/2021 | 350 | 01/07/2021 |
40163 | 01/06/2021 | 50 | 01/07/2021 |
As you can see above, the total Forecasted Units for 2021 should be 400 for Material 40163, as I am considering what is forecasted for the month (Forecast Date). What I am getting in Power BI is the total sum of everything visible, hence 800 units:
Additional info:
The question would be what is the best DAX command to use in order to "remove those duplicates"? should I create a new forecast Column or Measure? Which in this case means having for Material 40163, just 400 units Forecasted. |
I apologize in advance if I wasn't clear explaining my issue, and please let me know if I can add any extra info that can be of help.
I thank you for your time.
Kind regards,
Hi @serzott
Has your problem been solved ? If it has been solved, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regard
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @serzott
You can use DISTINCT DAX to remove the duplicates . Due to the data you provided is not enough for me to restore the test scenario, you can refer to the links I provided to find a suitable solution.
https://docs.microsoft.com/en-us/dax/distinct-function-dax
Best Regard
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
42 | |
26 | |
21 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |