bridge table and sumx helppp

[ezzz_]

I have two tables and bridge tables, How can I use sumx for 'getTimeLogs'[hours_spent]*'getTClientRateHistory '[client_rate],

pbi cant see the relation between getTClientRateHistory and getTimeLogs tables. I try to set that relation between a bridge table,but it didn't work 

[technolog]

I hope this message finds you well. I've noticed that this solution remain unresolved. If any of you have managed to find a resolution to the issue, I kindly request that you share your solution for the benefit of the entire community. Alternatively, if you're still facing challenges, please do let us know as well.

Your insights and updates will greatly assist others who might be encountering the same challenge.

[mlsx4]

Hi @ezzz_ 

Try something like: 

Revenues=
SUMX( CROSSJOIN(getTimelogs,getTClientRateHistory),
getTimelogs[hours_spent]*getTClientRateHistory[client_rate])

[ezzz_]

thanks but it didnt work again, pbi couldnt find getTClientRateHistory

[mlsx4]

And what if you try three measures?:

sumHourSpent = SUM(getTimeLogs'[hours_spent])
sumClientRateHistory = SUM(getTClientRateHistory '[client_rate])
mutiply = [sumHourSpent]*[sumClientRateHistory]

[ezzz_]

Dear mlsx4 I have overlooked sorry,

I have 2 tables;

clientratehistory and get time logs you can see below, recognizing in 'clientratehistory' (when timelogging date is more minor than rate-effective-date I have to take that rate) I have to choose that client rate, how can I do that??

please help meee

[mlsx4]

Wow... I'm afraid I would not be able to help much more. I'm also struggling with a similar problem regarding rates and dates. There's a guy which is trying to help me. Take a look at this thread (it may give you some idea) https://community.fabric.microsoft.com/t5/Desktop/Problem-with-granularity/m-p/3409032#M1132620

[ezzz_]

Thanks a lot for your effort:)