cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
thanosstef
Frequent Visitor

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

1 ACCEPTED SOLUTION

@thanosstef 

 

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

View solution in original post

6 REPLIES 6
mhossain
Super User
Super User

@thanosstef 

 

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

thanosstef_0-1633814249222.png

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

@thanosstef 

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

Fowmy_0-1633855471256.png

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

thanosstef
Frequent Visitor

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

Hi, @thanosstef 

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

 

 

 

@thanosstef 

 

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

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.