Forum Discussion
Solved
Filtering data table based on Today +14 days
Hello, I'd like to ask for help since I just started using PowerBI and bumped into problem I cannot solve yet. I can know a little bit of programming but this whole PowerBI/DAX is new to me (not...
Hello,
Sorry, this post was marked as spam for some reason so I tried at another forum.
The solution which worked for me is this:
When = switch(True(),[StartDate]=today(),"Today",[Startdate]>today() && [Startdate]<today()+14,"Soon",[Startdate]<today() && [DueDate]<today(),"Past",today()>[StartDate] && today()<=[DueDate], "Present",[Startdate]>=today()+14,"Future")This basically divides the past works, ongoing works, expected start of works "soon", and future works plus I added today's starting works as an added coloum to my data table.
Hello,
Sorry, this post was marked as spam for some reason so I tried at another forum.
The solution which worked for me is this:
When = switch(True(),
[StartDate]=today(),"Today",
[Startdate]>today() && [Startdate]<today()+14,"Soon",
[Startdate]<today() && [DueDate]<today(),"Past",
today()>[StartDate] && today()<=[DueDate], "Present",
[Startdate]>=today()+14,"Future")
This basically divides the past works, ongoing works, expected start of works "soon", and future works plus I added today's starting works as an added coloum to my data table.