measure column

2 Topics

How to create measures for data with many-to-many relationship
Hi everyone, I have these two tables connected by a key column, with a many-to-many relationship, I can't change this relationship setting, it is a limitation of my data sources, With that established, I would like to create a measure to put into a simple Table visual, that sums the value from one table with the other table, For example, I have this table 1: ID TABLE 1 DATE SHIP A 01/05/2023 MAERSK LAMANAI A 02/02/2023 CMA CGM RHONE A 03/07/2023 SAN VICENTE And this table 2: ID TABLE 2 POD TT A Tenerife 23 A Rotterdam 28 A Lisboa 25 A Las Palmas 24 A Bremerhaven 30 A Vado Ligure 30 When I connect both tables by column ID, I get the following table when I build it using the Table Visual: DATE SHIP POD TT 01/05/2023 MAERSK LAMANAI Tenerife 23 01/05/2023 MAERSK LAMANAI Rotterdam 28 01/05/2023 MAERSK LAMANAI Lisboa 25 01/05/2023 MAERSK LAMANAI Las Palmas 24 01/05/2023 MAERSK LAMANAI Bremerhaven 30 01/05/2023 MAERSK LAMANAI Vado Ligure 30 02/02/2023 CMA CGM RHONE Tenerife 23 02/02/2023 CMA CGM RHONE Rotterdam 28 02/02/2023 CMA CGM RHONE Lisboa 25 02/02/2023 CMA CGM RHONE Las Palmas 24 02/02/2023 CMA CGM RHONE Bremerhaven 30 02/02/2023 CMA CGM RHONE Vado Ligure 30 03/07/2023 SAN VICENTE Tenerife 23 03/07/2023 SAN VICENTE Rotterdam 28 03/07/2023 SAN VICENTE Lisboa 25 03/07/2023 SAN VICENTE Las Palmas 24 03/07/2023 SAN VICENTE Bremerhaven 30 03/07/2023 SAN VICENTE Vado Ligure 30 I would like to create a measure that sums the column TT to the column DATE, getting the expected result: DATE SHIP POD TT RESULT 01/05/2023 MAERSK LAMANAI Tenerife 23 24/05/2023 01/05/2023 MAERSK LAMANAI Rotterdam 28 29/05/2023 01/05/2023 MAERSK LAMANAI Lisboa 25 26/05/2023 01/05/2023 MAERSK LAMANAI Las Palmas 24 25/05/2023 01/05/2023 MAERSK LAMANAI Bremerhaven 30 31/05/2023 01/05/2023 MAERSK LAMANAI Vado Ligure 30 31/05/2023 02/02/2023 CMA CGM RHONE Tenerife 23 25/02/2023 02/02/2023 CMA CGM RHONE Rotterdam 28 02/03/2023 02/02/2023 CMA CGM RHONE Lisboa 25 27/02/2023 02/02/2023 CMA CGM RHONE Las Palmas 24 26/02/2023 02/02/2023 CMA CGM RHONE Bremerhaven 30 04/03/2023 02/02/2023 CMA CGM RHONE Vado Ligure 30 04/03/2023 03/07/2023 SAN VICENTE Tenerife 23 26/07/2023 03/07/2023 SAN VICENTE Rotterdam 28 31/07/2023 03/07/2023 SAN VICENTE Lisboa 25 28/07/2023 03/07/2023 SAN VICENTE Las Palmas 24 27/07/2023 03/07/2023 SAN VICENTE Bremerhaven 30 02/08/2023 03/07/2023 SAN VICENTE Vado Ligure 30 02/08/2023 I never worked with many-to-many measures, and I'm struggling to get the expected result, There is a way to solve this question? Thank you!
Solved
Anonymous
3 years ago Place DAX Commands and Tips
595Views
0likes
2Comments
Measure of date for a day before [Weekends Excluded]
Hello all, I have a simple DAX column that should adjust the date when data is written. date_adjustment = FORMAT(table_name[Created],"dd.mm" Since I am writing data today for day before I tried to get the date by adding date_adjustment = FORMAT(table_name[Created],"dd.mm" - 1 Problem with this is the data written on monday, will show the date of Sunday instead of Friday. For example 01/16/2023 was Monday and this data is for Friday 01/13/2023 and not Sunday 01/15/2023. How can I make it always ignoring weekends and all data from last Monday to be asigned to last Friday? Thanks
Nishlija995
3 years ago Place DAX Commands and Tips
528Views
0likes
2Comments