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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Ewa_28
Helper I
Helper I

How to create YTD measure, when one of the atrybute doesn't have a data for one week (for eed

Hi,

I created ytd, but when I prepare visualization it dosen't work, please see below. 

 

Ewa_28_0-1741771369556.png

 

I want to have data in the period of time where no data in source - it means that data should be taken from another period where exists and should be accomulated. 

 

Below you find my test data and pbix. Please help me!

link: https://1drv.ms/f/c/203304735e0bf790/EpJ_7UZrCmBIut1yynNGYD4B1LtCh7lhSBvUHZvjXt603g?e=MnWaHf

 

Regards, Ewa

2 REPLIES 2
Ewa_28
Helper I
Helper I

Please see below 2 charts - I prepare them in excel. As a result in Power BI I want to get the same result.

1.

Ewa_28_0-1741775070071.png

2.

Ewa_28_2-1741775116419.png

 

In Power BI I have:

Ewa_28_3-1741775394817.png

 

Please let me know if it is clear now.

vanessafvg
Super User
Super User

please provide your expected answer,  impossible to test the answer if the actual expected answer is not given.

 

please provide examples of what you expect.





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

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