Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Need help solving a practical FIFO issue, DAX measure or calculated column

Hello,   I have table that contains some sales data. I want to detect a product rotation issue. Effectively, I want each row to list the MAX production date of ENTRY TYPE SALE on a POSTING DATE tha...
Need Help
  • MFelix's avatar
    MFelix
    7 years ago

    Hi Anonymous ,

     

    Try the following measure:

    Last_date =
VAR Last_Date_Calculation =
    CALCULATE (
        MAXX ( 'Table'; 'Table'[Production Date] );
        FILTER (
            ALL ( 'Table'[Posting Date] );
            'Table'[Posting Date] < MAX ( 'Table'[Posting Date] )
        );
        ALLEXCEPT ( 'Table'; 'Table'[Item No]; 'Table'[Entry Type] )
    )
RETURN
    IF ( Last_Date_Calculation = BLANK (); ""; Last_Date_Calculation )

    Regards,

    MFelix

Anonymous's avatar
Anonymous
Not applicable
7 years ago

The works well as a measure, but is affected by a slicer. It does not perform within the context I was hoping. Is it possible to perform the same function using a calculated column, so I can simply pull it into a table row-by-row? In this case, it would compare against all of the other shipments of that item across the entire table's history.

MFelix's avatar
MFelix
Icon for Super User rankSuper User
7 years ago

Hi Anonymous ,

 

What is the context you were expecting? The measure can be change to overcome the slicer context.

 

Regards,

MFelix

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    MFelix ,

     

    I was able to modify my approach to make use of the formula you provided - thank you!

     

    MCKery

    • v-cherch-msft's avatar
      v-cherch-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      7 years ago

      Hi Anonymous 

      Glad to hear you've solved it, please accept the helpful reply as solution, that way, other community members will easily find the solution when they get same issue.

      Regards,