Forum Discussion

misterian's avatar
misterian
Regular Visitor
8 years ago
Solved

Time Intelligence not working for me

There must be someting I'm missing here. I can manually do the following to get YTD and it works on my data. That is it resets the total for each year etc. I would like to do a "TOTALYTD" version but...
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi misterian,

 

Where are the dates in the screenshot from? It would be great if you can provide a sample. Please mask the confidential parts first.

 

Best Regards,

Dale

misterian's avatar
misterian
Regular Visitor
8 years ago

Thanks for the help here. Here is a link to the files on Onedrive.

 

https://betatechinc-my.sharepoint.com/personal/butterworthi_btieng_com/_layouts/15/guestaccess.aspx?docid=1953edb3b5ec14affa75ade57792e31fd&authkey=AQyFXJ7uAFVVLm05Cy-HI5Q&e=ae0f34c0fe1b459184a5d3a1fc2dd72d

 

https://betatechinc-my.sharepoint.com/personal/butterworthi_btieng_com/_layouts/15/guestaccess.aspx?docid=1c87bd48cc61041c8834865eb03769e06&authkey=AdLm1Mm4840X8CZ5I_dW20o&e=d29864754a424bc7a09a4c9f6f7d714d

 

I've also done some more messign around and I think COUNTA may be the best way to count the events as it works on a columnar basis, but it does not slice or filter, e.g. by site.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi misterian,

     

    You may refer to my solution in this file.

     

    • misterian's avatar
      misterian
      Regular Visitor
      8 years ago

      Thanks, this gets me moving forward. I wish DAX wasn't so fussy.

       

      For example, for the calculated table formula. You used the successful

       

      Date = CALENDAR(MIN(system[AlarmTime]),MAX(system[AlarmTime]))

      And I had the not working following which DAX likes to put in when I type in the expression.

       

      Date = CALENDAR(MIN(system[AlarmTime].[Date]),MAX(system[AlarmTime].[Date]))

      Also I see the relationships are critical from the date table to my date fields. I note that the relationship is between a date time column and a date column. I guess DAX figures this out.

       

      Thanks

       

       

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        8 years ago

        You are welcome.