You can use references to use data contained in different parts of a worksheet in one formula or use the value from one cell in several formulas. Instead the DAX formula is automatically applied to the entire column. A reference identifies a cell or a range of cells on a worksheet and tells Excel where to look for the values or data you want to use in a formula.
Using Insert Function Option from Formulas Tab.
Note references are color-coded. By default Excel right-aligns numbers as shown below. If a valid sheet name is not given as reference REF. It is important to know that cells can store different kinds of values such as numbers text strings dates and Boolean values.