Forum Discussion
Solved
DAX Measure/Column Help
Hi All, Need a help to create DAX measure/column. There are 2 tables, below is the sample data 1.Year-Factor which has Factor for each year Year Factor 2021 1.035 2022 1.035 2023 1...
see attached
TotalCost=
VAR selected=SELECTEDVALUE(Year-Factor[Year])
VAR summed = SUMMARIZED('Fact',[Product],[Year],"PY")
VAR year='Year-Factor'[Year]
RETURN
'Fact'[Price]*(year+1,[Factor],"yf")*(yf+1,[Factor])
RETURN
sumx(year,PY)