Forum Discussion

misterian's avatar
misterian
Regular Visitor
8 years ago

PREVIOUSQUARTER returns nothing

Hello, this really has me stumped as everything else works OK! I can count and average if I put in manually the dates and the current quarter time intellignce works but not the previous quarter ones....
Need Help
mattbrice's avatar
mattbrice
Icon for Solution Sage rankSolution Sage
8 years ago

i thing i see is you are using two different calendar tables.  'Date'[Date] with time intelligence, and system[Alarmtime].[Date] when computing manually. Which is used in visual?  And does 'Date'[Date] have all contiguous dates needed?

  • misterian's avatar
    misterian
    Regular Visitor
    8 years ago

    Thanks, I suggest you open the PBIX file in the previous reply, as it will be faster for you and more informative that me trying to write a long post.

     

    For time intelligence the date table is used. The manual ones need the time from the same table as the average or calcrows value comes from. 'Date'[Date] uses the DAX create table from max and min dates for it. The bar graph works so this should all be OK.

    • Interkoubess's avatar
      Interkoubess
      Icon for Solution Sage rankSolution Sage
      8 years ago

      Hi misterian

       

      I opened your file and make a quick test, if you create a filled map with calendar date and let's vary the date you will notice that the Response Prev Q Avg works...

      The system needs to know what is the previous period so if you choose then the system can generate the previous quarter...

      Let us know if it is not working..

      • misterian's avatar
        misterian
        Regular Visitor
        8 years ago

        I'm not sure I understand what you are getting at. I need to have a card showing only the previous month's value, nothing else as part of my dashboard. The user must see only the previous Q relative to now without any interaction with the report.