Filtering a Table based on Group

DAX DAX Calculations
1

Hi,

I am working on conversion of Cognos reports into SSRS /Power Bi with tablular model in the backend.

One of the cognos reports have below expression for report filter.

[Date Time] = minimum([Date Time] FOR [Version])

I need to have same expression in the Dax ( which will be used in SSRS dataset) Below is the sample table I have.

TABLE

Any Help is highly appreciated.

2

@baijumohan,

This should work for you:

Min Date Per Version = 

CALCULATE(
    MIN( Data[date] ),
    ALLEXCEPT(
            Data,
            Data[version]
        )
    )

image

  • Brian

Note: I noticed after I posted that my screen grab didn’t OCR your data exactly right, so my results don’t match yours, but I believe the measure works correctly.

Here are two excellent videos on the use of ALLEXCEPT:

3

thanks Brian…i will check it out

4

Hi @baijumohan, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Thanks!