Forum Discussion

pankajdhillon's avatar
pankajdhillon
Frequent Visitor
10 years ago
Solved

TOTALYTD not working

I am using TOTALYTD but no output is coming from it TOTALYTD(COUNT(BookingDataAir[Bookings]),'DimDate'[full_date])   whereas when I use CALCULATE it works fine and gives expected result CALCULATE...
  • pankajdhillon's avatar
    pankajdhillon
    10 years ago

    Actually I realized my mistake, my formula was correct but when I was trying to visualize my data I was using date column from my BookingDataAir dataset rather than using them from DimDate dataset and due to that no value was coming for TOTALYTD. 

     

    Thanks everyone for help though.

     

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Question, what are your beginning year dates?  1/1/xx or 12/31/xx

 

Depending what you are trying to acheive, what I do is that I always want a current YTD kpi on my dashboard.  So I just utilize two different Measures.

1. Current Count: COUNT(xxxx)

2. Beginning of year count: OPENINGBALANCEYEAR(xxxx)

3.  Take 1 mins 2 and

 

This also assumes your data is accumulative in nature. 

pankajdhillon's avatar
pankajdhillon
Frequent Visitor
10 years ago

Even OPENINGBALANCEYEAR(COUNT(BookingDataAir[Bookings]),DimDate[full_date]) is giving me no result.