Forum Discussion
Multiple date difference and date count in a string
Hi, can anyone help me with implementing this? In my Dashboard I have 4 columns: A) Number of the issue B) Person Handling the issue C) Creation Date of the issue D) Comments on the issue ...
Anonymous , I think you have split it a few times in power query based on various delimiters
Like first into 2 columns using -
then based on space or something which can give email
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
amitchandak , but I don't need to grab the e-mail. The most important thing is that I need to calculate the date difference between comments published for an issue.
Anonymous -> for calculation date difference you can use DATEDIFF(date, comparison_date,DAYS). This will return the difference in dates in no. of days. eg- datediff(03/04/2021,04/04/2021,DAYS) will return 1
Anonymous ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
