Forum Discussion
DAX And PQ
Would this be of any help? If you scroll towards your right there would be a month column and right next to it is the today function, I am also sharing the formula used in the month column for reference. =IF(A2<>"Approved Vacancy","",IF(G2="ASAP",TEXT(TODAY(),"mmmm yy"),TEXT(G2,"mmmm yy")))
Vacancy Type | Vacancy | Contract Type | Hours | Approved Date | Approved by | Start Date | Staff Member | Notes | Recruitment Need | Talent Finder June start 0 | Board Report Category | Approved Week Number | Summary | Approved? | Nursery | Director Report Group | Month | 06/02/2024 |
| Pending Vacancy | NA | Staff A | 0 | ASAP | Replace X | #N/A | #REF! | Pending Approval | r | #REF! | ||||||||
| Pending Vacancy | NA | Staff A | 0 | 06/02/24 | Replace X | #N/A | #REF! | Pending Approval | r | #REF! | ||||||||
| Pending Vacancy | NA | Staff A | 0 | Replace X | #N/A | #REF! | Pending Approval | r | #REF! | |||||||||
| Pending Vacancy | NA | Staff A | 0 | 04/02/24 | Replace X | #N/A | #REF! | Pending Approval | r | #REF! | ||||||||
| Approved Vacancy | NA | Staff A | Replace X | ` |
your Start Date column is not Date format and can't be, that's why the M code couldn't find the date component in your code.
Can you please show me the out come I might look for a solution on my own. Thanks.
A quick question as the start date column has values like ASAP, Not filled when i change the format its coming as error. Or do u recon just change the format and see where it take to?
You can't change the format of the Start date column to Date. the columns conatins text format like ASAP ! . I don't know the business logic coming from you Excel to really answer your question, all I can tell is that you need to work on your excel file and remove all calculated columns from it in order not have suprises when publishing to the service.
