Calendar table - Event every x days

[Anonymous]

Hi,

I have a problem where I'm really stuck at the moment and I can't figure out how to solve it.

I want to add another column "eventX" which is a text to my already existing date table in Power BI.

My date column starts with 2020/1/1.

The Start date of the event series is 2020/1/3, from this day on every 3 days (e.g. 2020/1/6, 2020/1/9, 2020/1/12,...) the column should read "eventX" otherwise the column should be blanc.

Any Ideas?

Best regards and thanks for your help.

[amitchandak · Accepted solution]

@Anonymous , Try something like

if(mod(datediff([date], date(2020,01,03),day),3)=0,"EventX",Blank())