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

     

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