Rani has attended:
Power BI DAX course
Dates, time intelligence
Is it necessary for data to be in a date format with a date stamp, in order to use the time intelligence functions?
Would I need to convert my data from the format it is in into a date format?
RE: Dates, time intelligence
Hi Rani,
Thank you for the forum question.
Yes your dates must be recognised as dates (date formatted), and if you want to work with financial months, quarters, and years you must have a date table, if you want to use date intelligence functions.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
