Sajit Simon2 minExcelWhy do we need SWITCH function in DAXNested IF are good but in certain cases you might find yourself struggling with multiple IF statements within a single DAX due to the...
Sajit Simon2 minExcelHow to apply COUNTIF & SUMIF in DAXUntil now we have seen basic usages of DAX within Power Pivot, but now let's spice things up and use some nested DAX function to achieve...
Sajit Simon2 minExcelHow to create STAR SCHEMA in Power Pivot data modelBy now I assume that you might have already gone through my previous content & have a basic understanding of Power Pivot & how to work...