User Profile
georgec96
Helper II
Joined 4 years ago
User Widgets
Contributions
Year on Year growth DAX measure
Hi guys sorry in advance if this is a silly questions I am still trying to get the grasp of DAX I have the following dataset Store Ordered items Price per item Date ordered AA 89 £ 9.00 01/01/2022 AA 52 £ 9.00 01/02/2022 AA 66 £ 9.00 03/03/2022 AA 100 £ 9.00 02/02/2022 BB 6020 £ 9.00 02/02/2022 BB 2525 £ 9.00 02/02/2022 BB 1059 £ 9.00 02/02/2022 BB 10002 £ 9.00 01/06/2019 CC 512 £ 9.00 01/05/2023 CC 9999 £ 9.00 01/01/2020 CC 25 £ 9.00 01/01/2001 I am trying to calculate year on year growth however I am not sure what I am doing wrong as I cant get it to work. I have also created a calendar table and there is a relationship between them. I am using the following formula and can't figure out what is wrong with it. YearonYear= DIVIDE( SUMX('Aggregated data', 'Aggregated data'[Price per item] * 'Aggregated data'[Ordered qty]), CALCULATE( SUMX('Aggregated data', 'Aggregated data'[Price per item] * 'Aggregated data'[Ordered qty]), SAMEPERIODLASTYEAR('CALENDAR'[Date]) ) ) Any help would be much appreciatedCumulative sum based on other columns
Hi everyone, I've been struggling to write a calculated column to solve the following issue. I've got 4 columns: SKU,PO,Qty ordered and Qty on backorder. I need to create a column called "can_clear_backorders", that will calculate the amount of backorders a PO can clear based on the qty ordered but this needs to be a cumulative sum and it also needs to reset when there is a new value in column SKU. Any ideas how can I achive this? Sorry if my explanation is not clear enough, I've attached an image with the expected result as an example.Synoptic panel - warehouse layout dynamic conditional formatting
Hi All, I have a warehouse layout done in the synoptic panel visual, however I am trying to add a dynamic conditional formatting to it and not entirely sure how to do it. I don't want to set predefined values for the color coding as shown in this photo I want the color coding to be done automatically in the background based on the values ( showing most used locations in the warehouse based on the trnqty column in the dataset ) Each square represents a bay in the warehouse Is it possible to achieve something like this?First and last datetime stamp
Hi everyone, I have the following dataset I am trying to get the first and last datetime stamp for each shift (there are multiple shifts A,B,C,D) per day. I have tried this formula but it doesn't work due to duplicated rows in the trndte column. Measure = CALCULATE ( MIN ( 'Table'[trndte]), FIRSTDATE ( 'Table'[trndte] ) ) Any ideas would be much appreciated Thanks
