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, I could not understand which month of the date is your standard date?

Also you could refer to below steps to get your start of month and end of the month:

Apply it and use below formulas:

Column1 = IF('Table1'[DownStart]<=[End of Month],TRUE())
Column2 = IF('Table1'[Downend]>=[Start of Month],TRUE())

Result:

 

You could aslo download the pbix file to have a view.

 

Regards,

Daniel He