Identifying and listing duplicates across multiple columns
I am looking for a solution either in Power Query or in DAX to be able to identify customer orders which are placed by error more than once. A customer order (Order ID) is considered 'duplicate' if there is another Order ID with the: - same Order Date + - same Customer Reference + - same List of Materials + - same Order quantities for each material. It is important that one order usually consist of multiple Material codes and we want to find 'duplicate' orders only if the whole list of material and order quantities are the same. Any help appreciated.
Subtract a constant from a measure
I'm trying to create a measure on DAX that have to subtract 2 measures from a constant (that is 14). The problem is that when I calculate it it duplicates the results row. Here's the formula: Missed flows = (14 - CALCULATE( DMSFact'[# Not Available] ) )-'DMSFact'[Dealer_TOT_Y] where # Not Available and Dealer_TOT_Y are two count measure: Dealer_TOT_Y = CALCULATE(COUNT('DMSFact'[Dealer Int]) ,'DMSFact'[Dealer Int]="Y" ,GROUPBY('DMSFact','DMSFact'[Dealer Code])) # Not Available = CALCULATE(COUNT('DMSFact'[Flag NotAvailable]) ,'DMSFact'[Flag NotAvailable]="Y" ) The result I want to display is the Missed flows for each dealer, in such a form: Insted I get this:
Rolling Forecast by month - Forecast accuracy of the year
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: I have a Dates table All data for Forecast units and Sales units is coming from a consolidated Forecast table and is working for monthly calculations (Fcst Error, Abs Error, Accuracy, Bias) Relationships: The forecast source file is at this WeTransfer link: https://we.tl/t-T7AjGKBrOF 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,
Is there a way to count the amount of date overlaps?
Hi, I have the following Table: Where DischDate = '2020-02-20' means no discharge date; just to replace NULL value Is there way in DAX Power BI - to calculate the amount of Overlapping dates for each Client (EHRClientFK), as per following "Overlap" schema: According to the schema only EHRClientFK values dates = 2,3,4,5 should be counted Values 8,9,10 have are only single; values 6,7 have no Ovrelaps So, my goal is to have something like: EHRClientFK # of Overlapping Dates 2 2 3 2 4 2 5 2 Thank you for any suggestions!
