Dynamic date table and language

Hi Anonymous ,

>>1.To be able to use all dates functions in DAX, do I need the date table to cover a full year even though I do not have data for the full year?

No, you don't have to make the data table cover a full year. You can even create a calendar table for it . About fiscal year, please refer to https://www.powerobjects.com/blog/2018/12/19/sorting-data-fiscal-year-power-bi/

>>2.Changing language for dates: I use English as language in Power BI, but get the dates in Swedish format. 

Power bi currently does not provide this function, it is recommended that you use some translation tools/functions. Please refer to the similar issue: https://community.powerbi.com/t5/Desktop/Change-language-in-date-year-month-day/td-p/75731

Best Regards,

Dedmon Dai