Your DAX calculated columns aren't the end of the world...

What new functions added in DAX during 2022

This can answer questions like - How many of our employees didn't participate in a conference.
A table contains the names of persons who enrolled to attend a conference. Another table contains the names of participants of the conference from different organizations.
We need to find from our organization who all didn't attend the conference.

The Excel file used in this can be downloaded from - https://1drv.ms/x/s!Akd5y6ruJhvhvyiKR16pp0AxtQT_?e=gjQWKB

In data processing, you may be required to remove rows and columns which contains only null. They won't add any value to data analysis.

Learn to remove blank rows and columns in Power Query from your data set.

The Excel file used in this can be downloaded from - https://1drv.ms/x/s!Akd5y6ruJhvhvySRn_3JtSEjiHoy?e=mi60gP