Forum Discussion
Solved
dax query
Hi Community team, need you help on one of the dax query, please find the below snap and understand my rrequirement, write a dax query on that, I have year, period, sales fields, want to find ou...
Whenever you have the opportunity to, share the download link of the PBI file with a Calendar Table and a Period column in the Calendar Table.
don't have the option for sharing and for uploading the pbix file and data file
create a calendar manually from 01/01/2021 to till now
I have return the below dax query for the CY getting accurate value, PY variable have the issue only, It is fetching all the periods sum value, I don't want to get it all, which are the periods are available that periods should get in previous year also
VAR selectedyear=SELECTEDVALUE(Sunchips_MP[YEAR])
VAR MAXPERIOD=MAX(Sunchips_MP[PERIOD])
VAR cy =
SUMX(
FILTER(Sunchips_MP, Sunchips_MP[YEAR] = SelectedYear&&Sunchips_MP[PERIOD]<=MAXPERIOD),
Sunchips_MP[TOTAL OCCASIONS]
)
VAR py =
SUMX(
FILTER(Sunchips_MP,Sunchips_MP[YEAR] = SelectedYear-1&&Sunchips_MP[PERIOD]<=MAXPERIOD),
Sunchips_MP[TOTAL OCCASIONS]
)
VAR maxyear_GROWTHRATE=(cy-py)/py