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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Milan
Frequent Visitor

How to use date format in functions

Hello guys,

 

i am trying to use calculate formula for filter values, but i don´t know how to work with date in filter section of formula.

Formula is: 

 

Column 1 = CALCULATE(SUMX(FILTER(RELATEDTABLE('Warehouse status'),'Warehouse status'[Warehouse]="1"),'Warehouse status'[Amount]),'Warehouse status'[Date]=30.06.2021)
 
Column 'Warehouse status'[Date] has data type date. 
 
What is correct typing for using date type in functions?
 
"30.06.2021"or 30/06/2021 not working
 
Appreciate your help
 
Milan
 
1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

@Milan 

pls try 

date(2021,6,30)





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

1 REPLY 1
ryan_mayu
Super User
Super User

@Milan 

pls try 

date(2021,6,30)





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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