Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

dateadd using with other dimensions

hi all , 

 

i use dateadd to compine TY sales With LY sales .

 

i want to put product category on rows and sales on values . 

 

how can i do this?

 

thanx for your help

Need Help
Show and Tell
Tips and Tricks
  • mhossain's avatar
    mhossain
    4 years ago

    Anonymous 

     

    Can you try 'Edate' function inspite of dateadd, and try as Fowmy suggested. Does it solve?

6 Replies

  • mhossain's avatar
    mhossain
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Anonymous 

     

    Provide more details what exactly you are trying to achieve, maybe screenshot or dummy pbix.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      LY Sales i measure it with dateadd and i want to put it in a table like screenshot

      • Fowmy's avatar
        Fowmy
        Icon for Super User rankSuper User
        4 years ago

        Anonymous 

        You can use a Matrix visual, add product category on Rows and the two measures in the values section