Forum Discussion

JCortez's avatar
JCortez
Frequent Visitor
1 year ago
Solved

Date Calculation

I have these SQL tables below and I am trying to calculate that date difference between these two columns: Client_Assessment.clas_date - Client_Program.start_date I am getting this error below,...
Need Help
  • kushanNa's avatar
    kushanNa
    1 year ago

    Hi JCortez 

     

    See if this Calculated Column DAX Query helps you 

    DateDiff_Days = 
VAR StartDate =
    CALCULATE (
        MIN ( Client_Program[start_date] ),
        FILTER (
            Client_Program,
            Client_Program[client_id] = Client_Assessment[client_id]
                && Client_Program[serv_id] = Client_Assessment[serv_id]
        )
    )
RETURN
IF (
    NOT ISBLANK(StartDate),
    DATEDIFF(StartDate, Client_Assessment[clas_date], DAY),
    BLANK()
)

    I have attached a sample PBIX file. I have tested this code and built it without any relationships, since I’m not sure how you have set them up in yours. Feel free to play around with it and see if it works for you as well. 

     

     

v-kpoloju-msft's avatar
v-kpoloju-msft
Icon for Community Support rankCommunity Support
11 months ago

Hi JCortez,

Hope you had a chance to try out the solution shared earlier. Let us know if anything needs further clarification or if there's an update from your side always here to help.

Thank you.

v-kpoloju-msft's avatar
v-kpoloju-msft
Icon for Community Support rankCommunity Support
11 months ago

Hi JCortez,

Just wanted to follow up one last time. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.

Thank you.