Forum Discussion

GarryPope's avatar
GarryPope
Icon for Advocate I rankAdvocate I
4 years ago
Solved

DATEQTD showing Blank

Hello Power BI Community,  Could you please help with a DAX issue I have?  I have three tables: Transaction, Fiscal Calendar, Measures. In my Transaction table I have a list of Transactions wi...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, GarryPope ;

    I tested it, and I already know why. Your calendar is filled with dates for the entire 2014-2023 calendar year (up to May). I think THE QTD calculation uses the last quarter in the calendar, april-May 2023. There is no 2023 data in the Transaction table, so it appears blank in the card visual object. If I change the query on my calendar to show only through May 2022, everything works as expected.

    When i select  year 2013-2014. is not blank.

     

    Or you could change the measure as follow:

    Qtd = CALCULATE(SUM([ Sales]),FILTER(ALLSELECTED('financials'),YEAR([Date])=YEAR(TODAY())&&QUARTER([Date])=QUARTER(TODAY())))


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

GarryPope's avatar
GarryPope
Icon for Advocate I rankAdvocate I
4 years ago

Update... Okay, so I realised what I did. In the above DAX I used the column Date from my Fiscal Calendar table.

When I used the Date column from my Transaction table it gave the correct figure.


This is great, but my next question is please, why didn't the Date column in the Fiscal Calendar work?

Thanks,

Garry




  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    4 years ago

    Hi,

    Ensure that there is a relationship (Many to One and Single) from the Date column of the Transaction Table to the Date column of the Calendar Table.  Your initial measure should work.  Furthermore, in a card visual since ther is no filter context, I would not be surprised if you still see a blank.  For a QTD calculation to work, one must drag Year and Quarter from the Calednar Table (to a Table/matrix visual).