to get yesterday date based on today date

[rezaaditia]

Hi -

i have syntax formula from another BI Tool below

CASE DATENAME('weekday', TODAY())
    WHEN "Monday" THEN DATEADD('day', -4,TODAY())
    WHEN "Tuesday" THEN DATEADD('day', -4,TODAY())
    WHEN "Wednesday" THEN DATEADD('day', -2,TODAY())
    WHEN "Thursday" THEN DATEADD('day', -2, TODAY())
    WHEN "Friday" THEN DATEADD('day', -2, TODAY())
    WHEN "saturday" THEN DATEADD('day', -2, TODAY())
    WHEN "Sunday" THEN DATEADD('day', -3, TODAY())
END

now i want to use in Power BI... i was looking in google, since i am really new in Power BI, so mostly i don't understand 🙂

can you please suggest how to write that logic in power BI?

thanks in advance

[evandrocunico · Accepted solution]

Hi @rezaaditia 

create a new column and try this:

new_col = SWITCH(WEEKDAY(today();3);0;today()-4;1;today()-4;2;today()-2;3;today()-2;4;today()-2;5;today()-2;6;today()-3)

-- weekday(date; return)

return:

-- 1 = sunday is 1 to 7

--  2 = monday is 1 to 7

--  3 = monday is 0 to 6

best regards

[rezaaditia]

thanks @evandrocunico , its working the formula 🙂