Forum Discussion
Dynamic date table and language
Hi,
I have few questions regarding date tables:
- 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? Ie. if my data start at Feb 1st, do I still need the date table to cover Jan as well to be able to use all date functions in Power BI? Does this also apply to Fiscal years? I.e. do I need full fiscal years as well?
- If yes; how can I adjust below M code to dynamically create dates for full year, based on dates in my raw data? Current code for start date is: = List.Min(Table.Column("Table 1","Order date")) - so if the first Order date is e.g. Feb 1st 2018, how can I get a date table starting Jan 1st 2018 instead of Feb 1st 2018?
- Changing language for dates: I use English as language in Power BI, but get the dates in Swedish format. I have locale as Swedish when importing since I need that to import correctly, however I want the months to be spelled in English not Swedish in the imported table. How can I fix that? See below:
Need all dates, how ?
If using FY do I need all dates for the FY as well?
How change language?
2 Replies
Anonymous ,
Refer if this can help https://www.youtube.com/watch?v=jZQ4BZmtseo
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
