Forum Discussion
Merge and expand in direct query
Hi BeaBF, uzuntasgokberk
The reason I am asking this is, later I will have to do some other transformations like creating custom and conditional columns.
Any comments on this?
Max19 after set the relationship as above, you can use the RELATED function or simply recall the field in your measure.
Like:
BBF
Hey BeaBF ,
I tried creating a relation between the table VIEW_RFIS( (T1) which is my fact table and Workflow Type Status (T2) where the common columns are NotificationWorkflowStatusId from T1 and Status Id from T2.
for your reference. here is the T2 tableWorkflowTypeId StatusId StatusName WorkflowTypeName 2 10 Accepted Workflow de notificaciones 2 11 Rejected Workflow de notificaciones 2 12 Cancelled Workflow de notificaciones 2 15 Issued - Pending Construction Review Workflow de notificaciones 2 16 Issued - Pending Quality Review Workflow de notificaciones 2 17 Accepted Contractor Workflow de notificaciones 2 21 Accepted Contractor Workflow de notificaciones 2 22 Accepted Contractor and PID Workflow de notificaciones 2 24 Suspended Workflow de notificaciones
Now in T1, I wanted a column named Notification Status Name where if the NotificationWorkflowStatusId from T1 matches the Status Id, I wanted Status Name.
Else for nulls I wanted to remain as null.
After this, I have a column named NotificationStatus in the T1. Now, I wanted another column named NotificationStatusTemp in T1 where I wanted to apply a condition like below
If Notification Status (T1) = "Issued" then it should take the value from the Notification Status Name (FYi, Previously created column) else it should take the value that is in the Notification Status.
Based on this, I should have a column waiting Execution Result based on the below formula:
=if [NotificationStatus] = "Accepted" and [ExecutionStatus] = "Not started" then "Yes" else "No"
which I will use to create another column as shown in below snipLet me know if you can understand what I was trying to have.
Other Case:
I tried creating a relation between t1 and t2 using the common columns with *Id but when I execute the following dax it is not working and even it is not popping up the LOOKUPVALUE function.