Forum Discussion
Solved
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
