excel4

adds query tablesauto if detect relationship other files. ignore

relations in datA model cant loop

all beforename in dax measures for povot table makes column ignore corresponding row s that may filters

divide function([] instead of direct /  returns blank if cant fully do it so is safer

DIVIDE(<numerator>, <denominator> [,<alternateresult>])
CALCULATE(<expression>,<filter1>,<filter2>…)
<> is not equals to

DAX includes many functions that return a table rather than a value. The table is not displayed, but is used to provide input to other functions. For example, you can retrieve a table and then count the distinct values in it, or calculate dynamic sums across filtered tables or columns.

pic

Total Units Var: Total Units Var:=[Total Units]-[LY Total Units]

Total Units Var %: Total Units Var %:=DIVIDE([Total Units Var],[LY Total Units])
unit is revenue

Year-to-date (YTD) is a period starting from the beginning of the current year and continuing up to the present date
totalytd function

% Units Market Share: % Units Market Share:=IF([Total VanArsdel Units]=0, 0, DIVIDE([Total VanArsdel Units], [Units All Vendors], 0))

Cube functions allow Excel to access data from an Analysis Services data source without using a Pivot Table.

cubevalue function adds

powerbi crosshilighting click on chart as slicer filter other chart

powerview seehow affect other graphs
when edit report pin dif format save as new chart

ask a question about data search bar brings up charts applied with slicers based on enhlish statements