Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi,
I create a Calendar using a below code:
dcalendar3 =
ADDCOLUMNS(
CALENDARAUTO();
"Ano";FORMAT([Date];"YYYY");
"Mês";FORMAT([Date];"MMMM");
"Mês Curto";FORMAT([Date];"MMM");
"Núm Mês";MONTH([Date]);
"Trimestre";FORMAT([Date];"q");
"Mês/Ano";FORMAT(([Date]);"mmm") & "/" & YEAR([Date]);
"Ano Mês"; CONCATENATE(YEAR([Date]);FORMAT(MONTH([Date]);"00"));
"Dia da Semana";FORMAT([Date];"ddd");
"Núm Dia Semana";WEEKDAY([Date]);
"Dia Útil"; SWITCH(WEEKDAY([Date]);7;0;1;0;1);
"Feriado";LOOKUPVALUE(Feriados[Feriado];Feriados[Data];[Date];"")
)
I need to add a column to check if it's a business day or a holiday. And I'm using the following code for this:
Dias úteis sem Feriados = if(AND(dcalendar3[Dia Útil]=1;dcalendar3[Feriado]="");"Dia útil";"Dia não útil")
Sometimes when I add a new column, it causes an error in all the data in the column. It has already happened, for example, when I refer to one of the columns in the calendar, as is the case now. This time I had no mistakes, but they often haunt me.
Thanks!
Solved! Go to Solution.
I was making a basic mistake !!! You simply should have added the last column formula calculated within the one that created the calendar. So it stopped causing the error that happened when creating the new column.
I thank you in advance for the effort and attention of those who read this request!
HI @fabiojoa
Whta is error in your case? from the screenshot, it works well. and if is something wrong in your formula.
Could you please share your sample pbix file for us have a test.
Regards,
Lin
Hi!
Finally the error occurred, this morning when I opened the file ...
The column with my formula to find out if it is a working day or a weekend / holiday disappears and this one appears in error.
Thanks!
I was making a basic mistake !!! You simply should have added the last column formula calculated within the one that created the calendar. So it stopped causing the error that happened when creating the new column.
I thank you in advance for the effort and attention of those who read this request!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
99 | |
72 | |
44 | |
38 | |
30 |
User | Count |
---|---|
157 | |
90 | |
62 | |
46 | |
40 |