Forum Discussion

Roland74's avatar
Roland74
Icon for Helper I rankHelper I
1 year ago
Solved

How to get the highest value on the same date

Hi, im struggling with this case. I've got this table: (For the month June everything is the same, except the 'ResultID')  For a selected month i need the highest ResultID, i.e. for June i w...
  • Roland74's avatar
    Roland74
    1 year ago

    After some trial-and-error i found the solution, which was quite simple.

    MaxID_Calc2 = CALCULATE(
                    MAX(factProjectPreclosureResult[ProjectPreclosureResultID]),
                    ALL(factProjectPreclosureResult[ProjectPreclosureResultID]),
                    ALL(factProjectPreclosureResult[PostingDateID])
                    )
Roland74's avatar
Roland74
Icon for Helper I rankHelper I
1 year ago

After some trial-and-error i found the solution, which was quite simple.

MaxID_Calc2 = CALCULATE(
                MAX(factProjectPreclosureResult[ProjectPreclosureResultID]),
                ALL(factProjectPreclosureResult[ProjectPreclosureResultID]),
                ALL(factProjectPreclosureResult[PostingDateID])
                )