Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

@Anonymous 

 

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
Solution Sage
Solution Sage

@Anonymous 

 

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

Anonymous
Not applicable

thanosstef_0-1633814249222.png

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

@Anonymous 

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

Anonymous
Not applicable

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

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

 

 

 

@Anonymous 

 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.