Forum Discussion
findout date difference between two dates and non dates
Greg_Deckler i need both dax function in single caluclated column ,could you please suggest
Community ChampionMahamoodBi Right, that's a simple
IF( MAX('Table'[ServiceDate]) <> BLANK(),
( MAX([TermDate]) - MAX([ServiceDate]) ) * 1.,
... //second measure goes here
)
Greg_Deckler i need to divided by 12,because i am finding date difference between two dates by month
second point coding i didný understood could you please cexplain
- Greg_Deckler
MahamoodBi I can't provide you with a specific solution without sample data to build a model out and code it. Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.Emp.No Valid From Valid To Service.Date TermDate 15833 01-09-2014 00:00 03-11-2014 00:00 01-04-2014 28-04-2022 04-11-2014 00:00 08-01-2015 00:00 09-01-2015 00:00 31-03-2015 00:00 19031 11-04-2019 00:00 31-10-2020 00:00 11-04-2022 01-11-2020 00:00 06-07-2021 00:00 07-07-2021 00:00 11-04-2022 00:00 16097 06-10-2014 00:00 03-11-2014 00:00 06-10-2014 12-05-2022 04-11-2014 00:00 11-06-2015 00:00 12-06-2015 00:00 31-03-2016 00:00 11821 21-01-2008 00:00 24-06-2008 00:00 12-04-2022 25-06-2008 00:00 30-09-2008 00:00 01-10-2008 00:00 31-10-2008 00:00 01-11-2008 00:00 31-12-2008 00:00 pls check the sample data
1.i need to findout date difference between service date and term date.
2 if service date column is empty we should find date difference between Valid from(least value) and term date
3, above two condition should be single formula
thanks
.