Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi 

 I have tried everything I could used conditional columns, used multiple ways modified PQ formula with the help chatgpt but nothing seems to be working. I think the issue is that the column start date as values like "blanks", "Asap", and "dates". and the Today or now function is just not working.

 

Sharing one PQ  example: (if [Vacancy type] <> "Approved Vacancy" then null else if [Start Date] = "ASAP" then Text.From(Date.Month(DateTime.LocalNow())) & " " & Text.From(Date.Year(DateTime.LocalNow())) else Text.From(Date.Month([Start Date])) & " " & Text.From(Date.Year([Start Date])))

aj1973's avatar
aj1973
Community Champion
2 years ago

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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?.

     

     

    • aj1973's avatar
      aj1973
      Community Champion
      2 years ago

      Use an onlie service to upload the file, like OneDrive, Google Drive, Dropbox....