Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Dynamic Date Filters

I am trying to accomplish some tricky date logic.  Here is how it breaks down. Units in our operating system can go down for maitenance. We have a report that tacks this. I am trying to get my data t...
Need Help
v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

Hi Anonymous ,

From your sample data, could you want to calculate the [Start of Month] and the [End of the Month] and compare it with your date column? Your formula:

if('Down US'[DateStart]<='Down US'[End Start of Month]&&'Down US'[DateEnd]>='Down US'[Start End of Month],1,0)

It could work if all the columns is clearly, right? So I want to know the End of Month and the Start of Month should be calculated with which column? DateStart or DateEnd? I suggest you give a sample data and your desired result if possible?

 

Regards,

Daniel He

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Here is a sample of the data. The formula I listed is the condition that the date parameters needs to account for. I am not sure how to do that.  So for the given data set below if my paramers for start and end date are 3/1/2016 to 3/31/2018 I would expect the the first line, the 3-8 lines to show. Even though their start and end dates might be outside my range they are down during that period. I just do not know how to make a date filter that will use this logic.