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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
venucr9
Regular Visitor

Creating a measure to compare QTD with last year same QTD

I need help with creating a measure to compare current Quarter to date to last years Quarter to date. For eg if we are looking at Q3 CY 2018 on Sept 1st we shipped 100 items till now since start of Qtr, what was our position on Sept 1st last year in the quarter.

1 REPLY 1
v-yuta-msft
Community Support
Community Support

Hi venucr9,

 

"if we are looking at Q3 CY 2018 on Sept 1st we shipped 100 items till now since start of Qtr, what was our position on Sept 1st last year in the quarter."

 

<--- Could you share your sample data and clarify more details about your expected result?

 

Regards,

Jimmy Tao

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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