Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to manually edit within a New Table I created

Hi there.   So i've googled this and the answer isn't jumping out at me.    I created a CALENDARAUTO() table from Modelling ? New Table. I then added a WorkDay column which uses a formula to wor...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi Anonymous,

    Based on my test, you could use the IF function in the dax to solve your problem, if the 2018/1/1 is the the date you want to edit, you could create a new calculated column and use below formula:

    Column = IF('Table'[Date]=DATE(2018,1,1),"Hollday","Not Holiday")

    Result:

    Reference:https://msdn.microsoft.com/en-us/query-bi/dax/if-function-dax

     

    Regards,

    Daniel He

     

v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous,

Based on my test, you could use the IF function in the dax to solve your problem, if the 2018/1/1 is the the date you want to edit, you could create a new calculated column and use below formula:

Column = IF('Table'[Date]=DATE(2018,1,1),"Hollday","Not Holiday")

Result:

Reference:https://msdn.microsoft.com/en-us/query-bi/dax/if-function-dax

 

Regards,

Daniel He

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Daniel you clever thing you. I will absolutely do this!!!

 

Thanks!!!