Hello, so I am having trouble on how to add a YTD columns to my visual and I was hoping find a way to add a YTD value that counts the distinct value of all the dates beside the weekly values. Also if I can use the suggested solution in making YTD values if I wanted to make another visual for Daily, Monthly or Yearly.
YTD sample data - Google Drive
You'll need to use a disconnected table that includes the week numbers, as well as an extra row for YTD. Then, create a measure to return the value based on either the week number or whether the row is for YTD.
Please see the attached pbix.
You'll need to use a disconnected table that includes the week numbers, as well as an extra row for YTD. Then, create a measure to return the value based on either the week number or whether the row is for YTD.
Please see the attached pbix.
I tried using this and used it on my report but the YTD column is not showing and I noticed that the sample data used in the file you sent was shown as January1, February1,March1... the sample data should be from January1-10 could this be a factor on why the YTD column isn't showing?
Helpful resources
Power BI Monthly Update - April 2026
Check out the April 2026 Power BI update to learn about new features.
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
FabCon &SQLCon Highlights
Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.
