Forum Discussion
TotalQTD Not Working
I have the following formula for a quarter to date total,
4 Replies
Check Date table has all dates and it has been marked as dates.
Display Qtr-year from date tables along with Shipment measure.
Also, share calculation of shipment measure.
And try
Shipment $ Measure QTD = calculate(TOTALQTD([Shipment $ Measure], ('Auto Date Table'[Date Table Date])),all('Auto Date Table'[Date Table Date]))
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on LinkedinI tried the new formula and am getting thes ame result. Here is the formula for the Shipment $ meaure.
Shipment $ Measure = CALCULATE(SUM([Shipment $ Calculated Column]))
Hi, TDBoston
Based on your description, you may check if the date from 'Auto Date Table' and the date from 'CO Shipments' are all date data type. Then you can try to use the date from 'Auto Date Table' in the table visual. For further information, you may refer to the following link.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey Alan;
I confirmed they are the same date data type. I included both dates in my visual. You will notice that the data from the autodate table does not have a value for each shipdata value.
Best Regards,
Tony
