Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Need help with DAX | Creating Dynamic values

HERE IS LINK TO PBIX FILE : https://1drv.ms/u/s!Agarkj-fHbLWjgkn-5Cm64lDbHgU    Hello Community,    I have the data where I want to find the Multi product Users by calendar year and in all given ...
  • lbendlin's avatar
    lbendlin
    4 years ago

    Not sure if this is what you want but I remodeled your table slightly.

    Modified = UNION(SELECTCOLUMNS('Table',"ID",'Table'[ID ],"Year",'Table'[Years],"Scope","This year","Count",'Table'[Total Products in Calendar Year],"Category",'Table'[Category Products in CAL. Year]),SELECTCOLUMNS('Table',"ID",'Table'[ID ],"Year",'Table'[Years],"Scope","All years","Count",'Table'[Total Products in ALL Years],"Category",'Table'[Category Products in ALL  CAL. Year]))

     

    see attached

     

     

     

lbendlin's avatar
lbendlin
Super User
4 years ago

Not sure if this is what you want but I remodeled your table slightly.

Modified = UNION(SELECTCOLUMNS('Table',"ID",'Table'[ID ],"Year",'Table'[Years],"Scope","This year","Count",'Table'[Total Products in Calendar Year],"Category",'Table'[Category Products in CAL. Year]),SELECTCOLUMNS('Table',"ID",'Table'[ID ],"Year",'Table'[Years],"Scope","All years","Count",'Table'[Total Products in ALL Years],"Category",'Table'[Category Products in ALL  CAL. Year]))

 

see attached