Can I use DAX for this?

[snoozee]

Hi

I have two tables, one has a date column containing the current months dates, the second table contains entries that have been made over the month by various individuals.

What I need to do is check whether each individual has made an entry for each day of the month.

Is there a DAX formula that would do this for me?

 

[JustynaMK]

Hi,

Absolutely. You can, for example, use COUNTROWS to count the number of rows for the full month (first table) and compare it with COUNTROWS for each individual for every month (second table). Please post some exemplary data and the expected result, that will help me to create an exemplary DAX formula for you.