Hello I need help on Matrix report in Power BI

[poojagouspur1]

Can you please help if we can achieve the data as shown in the above screenshot by using the Matrix Component.

If I add the Actuals and Allocations in the Values section both the data is visible for past,current and future dates.

But I need Actuals and Allocations for Past and current and for Future only Allocations need to be displayed.

Please help if there is any way to achieve it.

Thanks.

[poojagouspur1]

@amitchandak  Thanks for the Solution!!

Through this I am able to achieve the Column headers like Last 1 Week,Current and Next 1 Week.

But under that I need to show Actuals and Allocations both only for Current and Last 1 Week.

For current+ 1 week or Next Week only Allocations should be displayed.

Can we achieve this through Matrix component like restricting the display of Actuals column under  Next 1 week Header and showing only Allocations for next week ...

Thanks !!

[amitchandak]

@poojagouspur1 , Create the a column this in date table 

=

var _startweek = [date] -1*weekday([date],2) +1

var _today= today() -1*weekday(today() ,2) +1

var _diff = quotient(datediff(_startweek , _today, day),7)

return

Switch(true(),

_diff = 0, "Current Week",

_diff < 0, "Last " & _diff & " week" ,

_diff > 0, "Next " & _diff & " week"

)