Forum Discussion
Date Hierarchy in Service with Excel file as Dataset
I am using an excel file in One Drive as the dataset for a report. Is it possible to format the date in a way that it will pull in a date hierarchy instead of just the date? Right now it is pulling ...
Hi tsachse ,
Create a calculated column like below
date = DATE('table'[year],'table'[month],'table'[day])Or you can add custom column in Query Editor
Date.From(Text.Combine({[year],[month],[day]},"/"))
Best Regards,
Jay
Anonymous Are you saying to create the calculated column in the Excel file or in PowerBI? I was hoping to avoid using PowerBI desktop so that the report would update without me having to open PowerBI desktop and refresh it.