Forum Discussion
DAX And PQ
Excel data set has a column "Start Date" and column " Vacancy status". There is a formula which is created in excel to extract "Name of the month" in the data set. which is causing an error while ref...
In previous thread I told you that calculated columns in Excel must not be used in Power BI.
If you can send me a sample of your excel file and the desired outcome I will be better helpful
Hi Aj
Its a live excel which gets updated every minute so I am attaching a copy of the sheet with just the relevant details pertaining to this issue. If you see towards the end of the sheet there would be a column called Month and thats what the issue is all about. Kindly look into it and let me know, I do not have the option to attach the file could you help on that too pls?.
Use an onlie service to upload the file, like OneDrive, Google Drive, Dropbox....