Forum Discussion

Paramjit's avatar
Paramjit
Icon for Helper II rankHelper II
4 years ago
Solved

column with Maximum value with filter condition

Hi Team,   I have two columns ID and Actual Start Date in direct query.  I need another column to get the maximum of Actual Start date where ID = 1000   ID Actual Start date 1000 1-Jan-2...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Paramjit ，

    Since you are using Direct Query mode to connect to the data source, you cannot create a custom column. This is a limitation of Direct Query connection mode. You can review this official documentation below for more details.

    Limited data transformations

    There are also restrictions on creating calculated column as follows:

    Modeling limitations

    You can create a measure as suggested by amitchandak :

    Measure = MAXX(FILTER(ALLSELECTED('Table'),'Table'[ID]="1000"),[Actual Start date])

    Best Regards

Paramjit's avatar
Paramjit
Icon for Helper II rankHelper II
4 years ago

Anonymous thank you. 

 

I am using direct query and not able to find the maxx and calculate function in custom column.

 

thank you,

Paramjit

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Paramjit ，

Since you are using Direct Query mode to connect to the data source, you cannot create a custom column. This is a limitation of Direct Query connection mode. You can review this official documentation below for more details.

Limited data transformations

There are also restrictions on creating calculated column as follows:

Modeling limitations

You can create a measure as suggested by amitchandak :

Measure = MAXX(FILTER(ALLSELECTED('Table'),'Table'[ID]="1000"),[Actual Start date])

Best Regards