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

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

     

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

    There could be different ways to solve it but the best way left is to share a sample of your pbix.