DAX function Date requires 3 parameters as number
Date(year, month, day)
Example: Date(2022, 2, 17)
This will give date as "2022-02-17"
DateValue converts a text string to date time
Example: we have year in one column and month name as "feb" in another column.
And we want to combine year & month to date column, we can write as below
DATEVALUE("1-"&fact_sales_Iphone14[month]&"-"&fact_sales_Iphone14[Year])
No comments:
Post a Comment