Forum Discussion

brunofds's avatar
brunofds
Icon for Helper I rankHelper I
3 years ago

Unusual QUARTERS - DAX

Hello there. Dealing with a problem here in my dataset.     For the sake of simplicity, I have a simple database with DimDate (from jan.1 to December 31) and FactOrders, using NorthWindDataset for ...
Need Help
aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
3 years ago

Hi brunofds 

You need to change the structure of your DimDate, meaning that the Calendar Year should start from December 1st

  • brunofds's avatar
    brunofds
    Icon for Helper I rankHelper I
    3 years ago

    Hey there. Thanks for your reply.

     

    Unfortunately i can't because i need to show my other measures in the current method, from Jan. 1 to Dec.31. 

    This is an exception...

    • aj1973's avatar
      aj1973
      Icon for Community Champion rankCommunity Champion
      3 years ago

      You can add another Date Table or add other columns to your DimDate and use Inactive Relationship for calculations.

      • brunofds's avatar
        brunofds
        Icon for Helper I rankHelper I
        3 years ago

        Adding other columns to my existing table would be the best choice right now.

         

        Could you be more specific?

         

        I've already tried to add a new "Quarter Column", but with no luck regarding to year filters...