Filtering a Table based on Group


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.


Any Help is highly appreciated.


This should work for you:

Min Date Per Version = 

    MIN( Data[date] ),


  • 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:

thanks Brian…i will check it out

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!