Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi,
I am trying to make an if statement for a new custom column, where the rows will:
- have -1 if the row in the old column contains a date
- have 0 if the row in the old column contains null
- have the count of non-empty rows from the old column if the date is 01.09.2022 (essentially what would be COUNTA([old column] in dax).
I have the following code, where "insert right formula here" is the part I need help with:
= each if [old column] = #date(2022,9,1) then "insert right fomula here" else if [old column] = null then 0 else -1
Any help will be sincerely appreciated!
Solved! Go to Solution.
replace "insert right fomula here" with:
List.NonNullCount(PreviousStepName[old column])
replace "insert right fomula here" with:
List.NonNullCount(PreviousStepName[old column])
Thank you!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
13 | |
9 | |
8 | |
7 |
User | Count |
---|---|
17 | |
10 | |
7 | |
6 | |
6 |