Basic Flashcards
where is the Data profiling
in View
handling blank
better convert it to null
for space needs to trim it first
and or statement
only take in 2 conditions?
if multiple conditions
no switch in M but in DAX
load vs load to
mostly always use load to
after the query is saved, change it at the query panel
table or connection
connection only load to memory
add to data Model
depends on if you need the data model
change data type
just click on the top left icon
rename header
double click on the title
merge query
basically is joining two tables
it adds column to the table
it may change row numbers depending on join method
append query
stack table with common column structure
it adds row to the table
definition of pivoting
turning distinct row to columns
import from current workbook
“From Table/Range”
= Excel.CurrentWorkbook(){[Name=”Table2a”]}[Content]
if query is too long
extract previous to split it into 2 queries
