dateadd using with other dimensions

[Anonymous]

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

[mhossain]

@Anonymous 

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

[Anonymous]

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

[Fowmy]

@Anonymous 

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

[Anonymous]

LY Sales i measure it with dateadd so i can t do it

[v-easonf-msft]

Hi, @Anonymous 

I'm not quite sure what you mean by 'LY Sales i measure it with dateadd'.

Can you share the formula you are currently using?

Best Regards,
Community Support Team _ Eason

[mhossain · Accepted solution]

@Anonymous 

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