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

     

luxpbi's avatar
luxpbi
Icon for Helper V rankHelper V
7 years ago

Hi Anonymous,

 

Just select a column of the table and the code will appear in the DAX box (don't really know hoy to call it)

 

Regards.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Luxpbi,

     

    I don't want to edit the code... I want to actuall select a cell in the table and change the value. I wonder if I can manually add the holidays into the formula instead, so like an if(25 december 2018, 0, else... then do the calculation. 

    • luxpbi's avatar
      luxpbi
      Icon for Helper V rankHelper V
      7 years ago

      Sorry my bad, I didn't understood you well enought. 

      You can't modify a cell but you can do it with code. 

       

      Here is one of the best solutions there is: 
      SQLBI Working Days

      Edit:
      You can also download the calendar template and check how it's done:
      Calendar template