Hi all,
I recently came accross a requirement to get a calculated column that gets a GCD of multiple values in the related table. Unfortunately, DAX syntax for GCD is for only two values.
My case it will have 1 to many values in it.
Kindly please anyone suggest any workaround for GCD (Greatest Common Divisor).
The data set is as follows.
| Material Request | Time | ID | Request | Confirmed |
| 43287 | 6:09:32 PM | ALKDE | 4 | 18 |
| 78744 | 6:37:49 PM | SDKED | 3 | 20 |
| 46447 | 10:33:38 AM | ALKDE | 5 | 36 |
| 87118 | 11:39:09 AM | ADKED | 4 | 10 |
| 25660 | 2:38:27 AM | CNEDD | 2 | 12 |
| 36598 | 5:42:56 AM | ALKDE | 7 | 27 |
| 76068 | 9:40:03 AM | SDKED | 10 | 15 |
| 89334 | 8:51:45 PM | ADKED | 4 | 50 |
| ID | Desc | Pen Size |
| SDKED | Storage | 5 |
| ADKED | Bottle | 10 |
| CNEDD | Bag | 12 |
| ALKDE | Couch | 9 |
In this Table 1 is the data table. table 2 to be added with a custom calculated column, where the two tables are related with ID column in both tables. The underlined column is the new column to be added based on table 1.
The result is as follows. For ALKDE = 9 (GCD of 18, 27 & 36).
Any kind help would be much appreciated.
Thanks
