Highlight where no-one has entered data for three weeks

[JemmaD]

Hi there,

I have a table of data in Power BI which is derived from users entering forecast figures for a given month. 

The managers want to have a report page which highlights those who have not entered their forecast figures for the previous month.

The data table only has the month and year for which the forecast relates so it's always the first of every month.

I am completely stuck because naturally the data table only holds the dates for which data has been entered - but I need to identify the 1st day of the previous month dynamically, which I have done as a measure, and then identify entries which have this date, or don't have this date? I have no idea. 

Any thoughts?

[danextian]

Hi @JemmaD 

Can you please post a workable sample data (not an image), your expected result from that and the reasoning behind. That way, it will be easier for anyone to help you.

[JemmaD · Accepted solution]

I've figured it out, I created a measure indicating whether the forecast entry was >0 or not, then filtered using  date logic to the previous calendar month! It was simple in the end.