Forum Discussion
How do we do the complex joins in PBI
hi , We are moving from OBIEE models to Power bi modles. The scneario i have it infront of me is, how do we do complex joins? We have a join as below to calucalte the cumilative number of registrati...
Please fin the use case below. The idea of below output is to see how many registrations are there in each week and it should be cumilative count.
JoyCornerstone
Resolver II
Resolver III'm not sure you need a complex join to get this working. If you have a DimDate table in your PowerBI model, you can have a week column there. Then you can use that "week" column in your output table and then add the EventID (count) to that column. Power BI would properly calculate the number of registrations in a given week if you joined the DimDate.Date and Reg_dt fields.