Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
ELYATIM
New Member

Fonction DATEDIFF not working

Hello All, 

i have a issue to use the function DATEDIFF

this is an example of the data table 

 

 Data 4 is a Mesure, and i want to use inside the function, but i cannot selected 

example : 

IF(Data 4 = Mesure,DATEDIFF(DATA1-DATA2),(DATA1-DATA3))

 

your helpl will be appreciated please 

 

thanks 

 

3 REPLIES 3
Anonymous
Not applicable

@ELYATIM  My bad 
but you still need to follow the syntax DATEDIF(Start_date,End_date,"Y")     
You can start date and end date and you need to select the interval as well
If you can provide little more context maybe I can be any help.

the problem is not DATEDIFF, im trying to use this function under a conditon 

for example if ( the mesure value = A, DATEDIFF(date1,date2,day))

bur is not working. i cant add the mesure to the function 

 

ELYATIM
New Member

i think you confusing the function DATEADD and DATEDIFF

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.