Power BI matrix Comparison Between 1st 12th Date vs Rest of Day in a month

[Arvind123]

Hi Team,

Can we accomplish Avg Profit of 1st to 12th date of current month Vs rest of the date comparison in Power Bi Matrix?
I want View like this is power bi matrix :

Campaign Name	Average Profit 1st 12 April	13th April	14th April	15th April	16th April	17th April	18th April	19th April	20th April
Ab	50	67	51	56	85	52	70	87	96
Cd	60	63	61	88	90	55	89	55	52
Ef	50	62	66	52	52	83	76	83	59

Here I have took till 20th April it may have 30th April or till 13th May data also but Avg profit of 1st to 12th April is fixed.

Thanks,

Arvind

[v-yuancha-msft · Accepted solution]

Hi @Arvind123  

Please follow these steps:

1.Create new tables with the information that you already have.

2.Select new column and use below DAX function.

Column = IF('Table'[Date]<=DATE(2024,4,12) && 'Table'[Date]>=DATE(2024,4,1),"Average Profit 1st 12th April", 'Table'[Date].[Month] &'Table'[Date].[Day]& "th ")

3.Final output.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Kuhn Chang

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