topic Re: bridge table and sumx helppp in DAX Commands and Tips

bridge table and sumx helppp

ezzz_ — Fri, 01 Sep 2023 08:22:09 GMT

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

Re: bridge table and sumx helppp

mlsx4 — Fri, 01 Sep 2023 09:50:54 GMT

Hi ezzz_

Try something like:

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

Re: bridge table and sumx helppp

ezzz_ — Fri, 01 Sep 2023 10:12:44 GMT

thanks but it didnt work again, pbi couldnt find getTClientRateHistory

Re: bridge table and sumx helppp

mlsx4 — Fri, 01 Sep 2023 10:19:09 GMT

And what if you try three measures?:

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

Re: bridge table and sumx helppp

ezzz_ — Fri, 01 Sep 2023 10:41:02 GMT

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

Re: bridge table and sumx helppp

mlsx4 — Fri, 01 Sep 2023 11:11:26 GMT

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

Re: bridge table and sumx helppp

ezzz_ — Fri, 01 Sep 2023 11:19:53 GMT

Thanks a lot for your effort:)

Re: bridge table and sumx helppp

technolog — Sun, 24 Sep 2023 08:00:30 GMT

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.