cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Help with Creating YTD Calculation without a Date Table

The source data for my data is already aggregated by quarter and year. There is no date-level detail so I do not have a date table. I need to build YTD total measures for the following:

• 2021 YTD Q1 = Sum(Q1 wRVUs)
• 2021 YTD Q2 = Sum(Q1 wRVUs) + sum(Q2 wRVUs)
• 2021 YTD Q3 = Sum(Q1 wRVUs) + sum(Q2 wRVUs) + sum(Q3 wRVUs)
• 2021 YTD Q4 = Sum(Q1 wRVUs) + sum(Q2 wRVUs) + sum(Q3 wRVUs) + Sum (Q4 wRVUs)
• 2022 YTD Q1 = Sum(Q1 wRVUs)
• 2022 YTD Q2 = Sum(Q1 wRVUs) + sum(Q2 wRVUs)
• 2022 YTD Q3 = Sum(Q1 wRVUs) + sum(Q2 wRVUs) + sum(Q3 wRVUs)
• 2022 YTD Q4 = Sum(Q1 wRVUs) + sum(Q2 wRVUs) + sum(Q3 wRVUs) + Sum (Q4 wRVUs)

This is my table:

Can someone help me with the DAX syntax to accomplish this?

2 REPLIES 2
Super User

Frequent Visitor

@lbendlin  thank you. I have now figured out the solution. I was confused because when I created a date table before and tried to connect my "Q1 2022" data field to the date table, it would not allow me because it's a many to many relationship.

What I figured out is that I just need to create a date field for all of my Q1 2022 data and set it to 1/1/2022 to connect to the date table. That's the part I was missing!

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

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

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors