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

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...

  • mangaus1111's avatar
    mangaus1111
    Icon for Solution Sage rankSolution Sage
    3 years ago

    HI brunofds ,

    see my pbi file.

    https://1drv.ms/u/s!Aj45jbu0mDVJizydWjv7d9vRhovx?e=vfevOe

    You have to add 4 additional columns named "Financial Quarter", "Financial Quarter Number" ,"Financial Year" and "Index"

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

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

      Hey thanks for your time.

       

      As i said to another user, I need a conventional DimDate Table.

       

      So in your example, my slicers wont be Financial Years, but the years itself:

       

      also using your example, the amount of 2020 would be the regular SUM:

       

      I need to create another measure but in this case, consider my "unusual quarter".

       

       

       

      thanks

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

        Hey brunofds 

        You now need to work on your calculated measures accordingly, probably add an Inactive relationship and use it to get the right display.

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

    Basically you start from adding an Index column like mangaus1111 did and the rest will follow.

    Nice exemple mangaus1111