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
jstorm
Resolver III
Resolver III

TOTALQTD not projecting forward in matrix, not showing data for quarter without sales

Charges QTD = TOTALQTD( SUM([charges]), Dates[Date] )

I have charges recorded for Q1,3, and 4 but there were no charges in Q2.  In my matrix, when filtering by Q2, the expected result should be the same running total as Q1 since there have been no further transactions. However, it returns blank.  Q3 and Q4 return the cumulative total as expected.  Furthermore, for the following year, I have Q1 data but no Q2-4 data.  I would expected the Charges QTD to return the same running total as Q1 for Q2-4, but it returns blank.

Can someone explain this behavior and how to change it?

1 ACCEPTED SOLUTION
jstorm
Resolver III
Resolver III

There was an error in the data, I discovered. Thanks for the reply.

View solution in original post

2 REPLIES 2
jstorm
Resolver III
Resolver III

There was an error in the data, I discovered. Thanks for the reply.

amitchandak
Super User
Super User

@jstorm , Not very clear. But QTD ends at the Quarter. So if Qtr does not have any data it will return null.

 

Can you explain with an example.

 

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.