Forum Discussion

Pmorg-73's avatar
Pmorg-73
Icon for Helper I rankHelper I
11 months ago
Solved

YTD measure missing month?

Hi   I have an oddity. I have used YTD to calculate cumulative invoicing as follows. I have a full daily date calendar table.   YTD Invoiced = IF(ISBLANK([Invoiced]), blank(), CALCULATE([Invoic...
Need Help
  • v-karpurapud's avatar
    v-karpurapud
    10 months ago

    Hi Pmorg-73 

    We would like to confirm whether the issue has been resolved. If it is still outstanding, please share any additional information so we can assist you further.

    Thank you.

kushanNa's avatar
kushanNa
Icon for Super User rankSuper User
11 months ago

Hi Pmorg-73 

 

It’s a bit difficult to say what the issue is without looking at your data. However, check if there are any blank / unusual format directors in the Directors column of your main table & silcer column . If so, they will appear as (Blank) in your slicer because it could not find a match in your director table column.

Also, filter for the months of August and May in your Main table and check for any blanks or data issues.

If you don’t find any of the issues mentioned above, and your relationships are set up correctly,

 

  • Invoices[Date] → 01_calendar[Date] (many-to-one, single) 

  • Invoices[Director] → Directors[Director] (many-to-one, single) 


your original DAX code should work as expected.