Custom date period table error when individual rows are identified

[Nath_nath]

Hello! 

I am operating the "custom date period" solution exactly as explained here: https://bielite.com/blog/custom-date-period-power-bi/

It is working mostly as planned with the exception when rows are considered. Then the complete filtering of the "Date Period" table is removed and you see all dates that are in the data. An example is when you create a measure as 

[CheckBlankRows] = IsBlank(Sum(FactTable[Fact]))

Or as can be seen in the screenshot:

 

 

The explanation of this solution (the link above) holds a power bi example file. I have attached this solution with the addition of what I have shown in the screenshot here. But it can also be simply replicated by downloading the initial file from the first link and then add the measure [CheckBlankRows]

Question:

Is there a way to solve this without too much hassle? My intention is to do this without too much hassle as I am working on a dataset that is used by multiple people and developers. Cumbersome workarounds have proved not to be the best maintainable.

Thank you!!

[v-xiaosun-msft]

Hi @Nath_nath ,

According to your description, I download the sample and here is my suggestion.

Please check whether the "DATE" you use is from table "Date Periods", if not, please change it.

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Nath_nath]

Hi,

Unfortunately this is not a solution as this won't work with other time intelligence metrics who need one table with unique dates.