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

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

        I'm not complete aware on how to solve this...

         

        Using the example above mentioned (https://easyupload.io/ianzro) , how can I turn the "average quarter" into the "correct" result, which is: 

        50+ 100 + 40

        / 3  

         

         = 63,33333333333333‬

         

         

         

        or the sum of amount (Amount_ measure_)  into 190?

         

        I'm aware of the filters and whats wrong here, but not sure how to solve it.

         

        Thanks