Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
There was an error in the data, I discovered. Thanks for the reply.
There was an error in the data, I discovered. Thanks for the reply.
@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.