to get subtotal for fact table that correlates to date range

[Umarjiman]

Hi everyone. How to put subtotal for January and February by using DAX?  

[v-stephen-msft · Accepted solution]

Hi @Umarjiman ,

I see that this thread doesn't seem to have been resolved. @Daniel29195 's reply is very helpful, and you can follow his suggestion to check the Column Subtotal option. If that's fine, you'll see something like this.

Best Regards,

Stephen Tao

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

[Daniel29195]

@Umarjiman 

im not sure if i understood your question .

setting subtotals are builtin in the power bi matrix visual . you can specify the level that you want your subtotals to show on . 

let me know if this works. 

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

[Umarjiman]

i've downloaded the latest pbi, and i still dont have that option. my task is to actually show the weekStartDate, but when I do it, the WeekStartDate for 29/01 aka 29th January on February column does not positioned itself correctly. it should be to the left of 05/02 aka 5th February. how do I solve this? 

[v-stephen-msft]

Hi @Umarjiman ,

I reproduced the matrix effect you wanted, and then I found the problem.

Your Week Start Date column should be similar to my formula below, and the start date of the 5th week is indeed January 29th, and the logic is correct.

You can work around this by grouping the months. Here's the modified calculated column.

Week Start Date = CALCULATE(MIN('Date Table'[Date]),FILTER('Date Table',[Year]=EARLIER('Date Table'[Year])&&[Week Number]=EARLIER('Date Table'[Week Number])&&[Month]=EARLIER('Date Table'[Month])))

And here's the result in the matrix.

Best Regards,

Stephen Tao

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