cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cpdanielmc21
Helper I
Helper I

Problem with QTD, not showing

Hi

I am having trouble with showing QTD. I created a time-intelligence measure, but only works if the visualization has a date column, but the total appears blank and if I add a Card, it also shows blank, don't know what I'm doing wrong, please help.

Capture.JPG

I have a table data and a separate calendar table with all days from Jan 1st 2020 till Dec 31st 2022, this is my data:

Capture2.JPG

My measure is:

TotQTD = TOTALQTD([TotalSales],'Calendar'[Date])

where TotalSales is just the sum of amunt in my data table

4 REPLIES 4
v-easonf-msft
Community Support
Community Support

Hi , @cpdanielmc21

If you must display the total value with the field "date" in Table  "calendar", It is recommended to modify the date table as follows:

 

 

Calendar = CALENDAR(DATE(2020,01,01),CALCULATE(MAX('Table'[Date])))

 

 

sample pbix attached

 

68.png

In additon ,you also can  insert a  record on "Dec 31st 2022" at the end of your data table.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Hi @v-easonf-msft thanks,

In fact, I don't want the Date info on the table nor the card, the issue is that if I take out the date from the table, then Quarter to date numbers don't appear.

 

Furthermore, the card keeps showing "blank"

AntrikshSharma
Resident Rockstar
Resident Rockstar

This is becuase there are no active filters over your card visual. Refer to the below image, the filter pane is applyting filters on the Card.
ant.PNG

nvprasad
Solution Specialist
Solution Specialist

Hi,

 

I assume you have created relationship between the sales & calendar table.

 

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

 

Regards,

N V Durga Prasad

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.