Extracting Value from a column based value of another in direct query

[Anonymous]

So i have this table with columns action and created_at. I want to get the date in created_at based on a value in action. I want the results as a column in which if the condition wasnt met , a "NULL" fill the cell. Important note is that i am using direct query which imposes so many restrictions . Here is a screenshot of a data sample from the table.

[Anonymous]

Hi @Anonymous ,

 I am also using Direct Query. Please check the text for errors.  Could you please tell me what is your data source? I am using SQL Server. My test version: 2.102.683.0 64-bit (February 2022).

I have also found some similar posts, please refer to it to see if it helps you.

Redshift and data folding error 

Data shows up in charts but not in table or matrix 

BigQuery malformed data in PBI 

If I have misunderstood your meaning, please provide your pbix without privacy information and desired output.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

i am using postgre sql database , i re checked the text but i am still getting the same folding error.

[Anonymous]

Hi @Anonymous ,

Could you please tell me that the type of the Action? If it is text, using max dax has no effect on it. And you are using Direct Query mode, you cannot use Selectedvalue dax.

Please have a try. 

Measure = IF(MIN('Table'[Action])="CALL_PATENT",MAX('Table'[created_at]),"null")

If I have misunderstood your meaning, please provide your pbix file without privacy information and desired output.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

you understood my meaning correctly. To answer your questions , I am using Direct Query which poses restrictions. The type of the action is indeed text . I tried the measure but it didn't work. A folding problem.

[Anonymous]

i basically want to do the same thing you showed me , but with the condition based on the action column not the 'true or false' in requires follow up column. so i think an IF measure works but MAX function needs to change 

[Anonymous]

So why are we basing the new column on the 'requires follow up' column ? i want the created measure to have the created date in the cell if the action is 'call_patient' , if not i want 'null' to fill the cell.  

[Anonymous]

Hi @Anonymous ,

Could you please tell me that how can you get the data in created_at based on a value in action?  The requires_follow_up is TRUE or FALSE? 

Please refer to my pbix file to see if it helps you.

Create a measure.

Measure = IF(MAX('Table'[requires_follow_up])="True",MAX('Table'[created_at]),"null")

If I have misunderstood your meaning, please provide your pbix file without privacy information and desired output.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.