For cases where our partitions as set on Year and Month, would we need to create an additional Month function and Filter step? Would it be possible to do it in one step if we concatenate the Year and Month like '202310' and do the filtering against this?
Extremely useful video!
For cases where our partitions as set on Year and Month, would we need to create an additional Month function and Filter step? Would it be possible to do it in one step if we concatenate the Year and Month like '202310' and do the filtering against this?
the incremental refresh do the merge in power BI?
Yes it does 😉