DAX Year Function Power BI

preview_player
Показать описание
Learn to obtain year from a date in power BI using DAX
Рекомендации по теме
Комментарии
Автор

Can the YEAR() function be used in an IF statement

giggles
Автор

Hi
can u guide me regarding power bi, i have tried this formula:year=year('file name'[Date]) but this is invalid.Why?

YasnaAfzal
Автор

Hi,

for the month name, instead of switch function you can just use format function as "FORMAT ( [Date], "mmmm" )"

MuhammetMustafaAslan