Forum Discussion
Resolver ICount Blanks Based on Two Columns Within Month
Thx for checking, but I ended up doing something much simpler:
CountBlanks = IF(ISBLANK([Gross Adds])&&ISBLANK([Device Upgrades]), 1, 0)Then I put in a measure to sum the CountBlanks:#DaysZero = SUMX(VALUES('Calendar'[CalendarDate]),[CountBlanks])
Super UserTo report on things that are not there you need to use disconnected tables and/or crossjoins
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Resolver II keep getting "Your post has been changed because invalid HTML was found in the message body." I clicked on the table and selected only one square like the instructions and pasted from a spreadsheet. I'm needing to know how I can count blanks if two columns are blank. If there are dates going across the top of the table 10/1 10/2 10/3 etc. Each date has two columns, Sales and Upsales. If both columns are blank that should count as 1. The Count Blanks column would have the total number of blanks across the whole date range.