DAX & DATA MODELLING

[AnzAsh66]

• 

   

  I need 1 help with respect to Power BI Data Modelling and DAX.
• I have Creation_date column in PO_HEADERS_ALL Table and Completion_date column in PO_REQUISITION_HEADERS_ALL Table.
• I need to create a measure which needs both these columns. Can you all please help how it can be done ?
• Also I have Calculated Column PO CYCLE in PO_HEADERS_ALL and Calculated Column PR CYCLE in PO_REQUISITION_HEADERS_ALL. I want to show both of these in a Table which will show these 2 along with a third column AGENT_NAME from PO_AGENTS_V. Please assist.

[lbendlin]

Please add a Calendar table to your data model.

[ahadkarimi]

try two measures below, and if you encounter any issues, let me know.

Date Difference Measure = 
DATEDIFF(
    SELECTEDVALUE(PO_HEADERS_ALL[Creation_date]), 
    SELECTEDVALUE(PO_REQUISITION_HEADERS_ALL[Completion_date]), 
    DAY
)

Is Creation Before Completion = 
IF(
    SELECTEDVALUE(PO_HEADERS_ALL[Creation_date]) < SELECTEDVALUE(PO_REQUISITION_HEADERS_ALL[Completion_date]), 
    "Yes", 
    "No"
)

Did I answer your question?  If so, please mark my post as the solution!
Your Kudos are much appreciated!  Proud to be a Resolver III !