Forum Discussion
Bakhtawar
Post Patron
Post PatronDifference between 2 columns in power bi
I am trying to take the difference between two columns. Below is an expression in qlik sense that I would like to translate into DAX LPO_DATE - (CLM_INTM_DT) +1 I tried this in power bi DAX but...
Tahreem24
Super User
Super UserNumber in terms of Day,month,or Year?
IF you want differences in number od Day, Month,Year etc. so this can be achieved by DATEDIFF or DATEDIFF DAX function.
Syntax:
1) DATEDIFF(Date1,Date2,Interval)
2)DATEDIFF(Date1,Date2,Interval)
Here Interval can be Day,month,Quater,year,Minute etc.
Please mark this answer as a solution so other will get help from this.
BakhtawarPost Patron
Post Patronhello i already tried that DATEDIFF function but when i tried eg .
DATEDIFF( here then i am trying to call date field CLM_INT_DT ) then this field did not appear