Can I show sales for the day,month & cumulative financial year in same matrix visual

[ThejaPGamage]

Dear all,

I have a Sales data Set with april 2022 to now. I am updating this every day morning. I need to show below data in same visual ( I use matrix)

Product Code	Sales Month to Date	Sales as at yesterday	sales year to date

Thanks

[ThejaPGamage]

Sample data set

product code	inv date		inv value
p1	01/04/2022	-	50
p2	09/04/2022	-	100
p1	01/05/2022	-	300
p2	11/05/2022	-	250
p1	05/06/2022	-	75
p2	06/06/2022	-	50
p1	08/07/2022	-	100
p2	12/07/2022	-	300
p1	23/07/2022	-	250
p2	30/08/2022	-	75
p1	31/08/2022	-	50
p2	01/09/2022	-	100
p1	11/09/2022	-	300
p2	21/09/2022	-	250
p1	30/09/2022	-	75
p2	01/10/2022	-	50
p1	06/10/2022	-	100
p2	15/10/2022	-	300
p1	02/11/2022	-	250
p2	07/11/2022	-	75
p1	30/11/2022	-	50
p2	01/12/2022	-	100
p1	09/12/2022	-	300
p2	01/01/2023	-	250
p1	02/01/2023	-	75
p2	15/01/2023	-	50
p1	19/01/2023	-	100
p2	04/02/2023	-	300
p1	07/02/2023	-	250
p2	08/02/2023	-	75
p1	15/02/2023	-	750

[FreemanZ]

hi @ThejaPGamage 

try to plot a visual with product code column and multiple measures like:

MTD = 
CALCULATE(
    SUM(TableName[inv value]),
    TableName[inv date]<= TODAY(),
    YEAR(TableName[inv date])= YEAR(TODAY()),
    MONTH(TableName[inv date])=MONTH(TODAY())
)

LastD = 
CALCULATE(
    SUM(TableName[inv value]),
    TableName[inv date]= TODAY()-1
)

YTD = 
CALCULATE(
    SUM(TableName[inv value]),
    TableName[inv date]<= TODAY(),
    YEAR(TableName[inv date])= YEAR(TODAY())
)

TD = 
CALCULATE(
    SUM(TableName[inv value]),
    TableName[inv date]<= TODAY()
)

it worked like:

[ThejaPGamage]

Sample DATA set

product code	inv date	inv value
p1	01/04/2022	50
p2	09/04/2022	100
p1	01/05/2022	300
p2	11/05/2022	250
p1	05/06/2022	75
p2	06/06/2022	50
p1	08/07/2022	100
p2	12/07/2022	300
p1	23/07/2022	250
p2	30/08/2022	75
p1	31/08/2022	50
p2	01/09/2022	100
p1	11/09/2022	300
p2	21/09/2022	250
p1	30/09/2022	75
p2	01/10/2022	50
p1	06/10/2022	100
p2	15/10/2022	300
p1	02/11/2022	250
p2	07/11/2022	75
p1	30/11/2022	50
p2	01/12/2022	100
p1	09/12/2022	300
p2	01/01/2023	250
p1	02/01/2023	75
p2	15/01/2023	50
p1	19/01/2023	100
p2	04/02/2023	300
p1	07/02/2023	250
p2	08/02/2023	75
p1	15/02/2023	750

expected out put

Product Code	Sales Month to Date	Sales as at yesterday	sales year to date
p1	1000	750	3075
p2	375	0	2325

[FreemanZ]

yes, with three measures each. paste some sample data and let us see.