Forum Discussion

Helper I

3 years ago

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...

Ashish_Mathur
3 years ago
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.

Super User

3 years ago

Hi,

So do you want to see the growth rate in a card visual. You will also need to share a Calendar Table with a column there of Period.

Helper I

3 years ago

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

Arjun_reddy
Helper I
3 years ago
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
Ashish_Mathur
Super User
3 years ago
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.
- Arjun_reddy
  Helper I
  3 years ago
  Sunchips MP Dash 08_21.pbix
  
  download the pbix file, use the page1 view and use the growthrate_occ measure, If py variable working fine, issue will resolve
  - Ashish_Mathur
    Super User
    3 years ago
    Takes me to a sign-in page. Ensure that in the file there is a Calendar Table with the Period column.

Related content