Hello,
I'm using the latest version of Power BI Desktop Application on Windows 10. I've downloaded data from the web interface but loaded it into the desktop to edit.
In my report, I have a simple table visualization that contains (1) field of department name, (2) field of employee full name, and then (3) hours worked data that is organized into columns based off days -- in my case, that is the last two weeks of July data (July 1 through 14). The SQL is setup to just refresh and grab the last 14 days.
I would like to add a conditional column to the right of this data that will simply print a "Yes" if the last 14 days of hours worked data have at least something populated in them. For example, if John Doe had worked 0.01 hours every day for the last 14 days, the conditional column created would display "Yes" and if one of those days was 0.00 if would display "No".
How would I go about solving this? I'm familiar with how to do something like this in Excel but everthing I've searched for has not been quite what I'm looking for...
