Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Calculate date difference between two columns

Hello,   I'm new to Power BI. There are two columns in Excel, each containing both dates and text. I want to import them into Power BI and only calculate the date difference of the rows containing...
General Comment
Need Help
  • DataNinja777's avatar
    DataNinja777
    2 years ago

    Hi Anonymous ,

     

    There are multiple ways to achive your required output even though the text descriptions have multiple variations.  My example below is based on the assumption that your text description variants do not contain "/" used in the date text. With this assumption the original calculated column can be modified as follows:

    Date Diff = 
VAR Date2 =
    IF (
        CONTAINSSTRING ( 'Table'[Date 2], "/" ) = TRUE,
        FORMAT ( 'Table'[Date 2], "m/d/yyyy" ),
        FORMAT ( 'Table'[Date 1], "m/d/yyyy" )
    )
RETURN
    IF ( Date2 - [Date 1] <> BLANK (), Date2 - [Date 1] )

     

    I attach a modified pbix file as an example. 

    Best regards,

foodd's avatar
foodd
Community Champion
2 years ago

Hello Anonymous, and thank you for sharing your question with other members of the Community Forum who are supportive.   Please remember to adhere to the decorum of the Community Forum when asking a question.

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523/highlight/true#M607150

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

 

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.  Proud to be a Super User!