I'm reaching out about resolving a blank workbook page. However, when I remove two filters including a date filter named (Exclude Current 2 Months); data appears into the workbook. The formula at question is a DateDiff formula.
Based on the currently written way what should the attended use and formula perform so it does result in a workbook with values. What is the significant points about >1 value along with the = 0 value.
Column name called Exclude Two Columns
(DATEDIFF('month',[Reporting Date],Today()) > 1 AND DATEDIFF('year',[Reporting Date],Today())= 0)
Thank you the calculation was valid. But referencing my screen shots below; the columns pill is in Month format while the workbook is still blank.
For values to be removed it required two other filters to be removed that are dimensions (non calculated). The results of the workbook is that is removes current month (feb 20)/previous month (jan 20)
Calculations impact - (Question1) Is it correct to say that this Datedif formula essentially subtracts the current/previous month from the worksheet?
(Question 2 ) The Year reporting date/period formula not equaling year (today() . But when I want to add months in 2020 should this be changed to be different?
(DATEDIFF('month',[Reporting Date],Today()) > 1 AND DATEDIFF('year',[Reporting Date],Today())= 0)
Year(Reporting Period)<>Year(Today())
