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.
Hi I really appreciate your effort and thank you ever so much for helping, Yeah, I have been moved in recently to build dashboards and the source what they have been using is formula based and cannot make much of a change in it. In this case any other suggestion? Cos the whole data set is depending on formulas of each columns. Other columns are working fine as of now but the today and dates creating havoc.