Incorrect value with measure - mystery

[shei7141]

Hi all,

I have two tables:

Table 1: DatabaseT

Column	Column	Measure	Measure	Column	Measure
Project	Phases	Start Date	End Date	TestCostPerMonth	CostPerMonth
A	A1	1/07/2021	30/11/2022	101373.6	101373.6
A	A2	1/01/2023	30/08/2024	172335.1	172335.1
A	A3	1/12/2024	30/11/2026	215418.9	215418.9

Table 2: Calender

DAX statement: 

Calendar = FILTER(CALENDAR("2010-01-01","2080-12-31"),DAY([Date])=1)

I cross joined the tables using the following

DatabaseForMonthlyRevised = FILTER(CROSSJOIN(DatabaseT,'Calendar'),'Calendar'[Date]>=DatabaseTab[StartDate]&&'Calendar'[Date]<=DatabaseTab[EndDate])

I created a viz table using the following fields:

- Date (from calender) - years only 

- CostPerMonth (column)

I nicely get the Estcost for year 

Years	CostPerMonth
2021	608241.6
2022	1115109.6
2023	2068021.44
2024	1585483.1
	and so on

but when I try to create the same table using CostPerMonth as a measure I no longer the same results

Years	CostPerMonth
2021	101373.6
2022	101373.6
2023	172335.1
2024
2025	215418.9

Is there something I am missing here?

Please assist me with me with situation>> I am stuck here for almost two days now 😄

Thanks Shei

[amitchandak]

@shei7141 , not very clear. But to deal with a start date and end date you can refer

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[shei7141]

thanks mate and apology for the confusion.

I am basically puzzled as I have same information in two formats (1. measure and 2. column) and when I create a tab viz, I get the correct answers with column but not with the measure.

Ta

Shei

[amitchandak · Accepted solution]

@shei7141 , In case measure row context will play role. Need to check with data.

[shei7141]

legend

! _ !