Last seen: Jun 27, 2026
Hi Alison, See file attached. In cells T22:Y29 is a new PivotTable containing your measures. For some of the measures it's complicated to have the ...
Hi Mardi, The problem occurs because the RFID that is being counted is not unique to a charge station i.e. the same RFID can appear in multiple cha...
Here is a comprehensive custom number format guide.
Hi Mardi, Thanks for sharing your file. The measure Consumption per Visit kWh had an error. You should get in the habit of clicking the 'Check form...
It returns the same result as your desired result example for 2017/2018 YoY, so please provide an example based on the file provided where the result ...
Hi Lam Lee, Sunny has answered your first question. In answer to your Year on Year calculation, I don't think your data suits a year on year calcul...
No, the 'value if true' calculates the customer percentages and the 'value if false' calculates the total percentages.
Hi Mardi, I can't see anything obvious wrong that would explain the discrepancy, but I'll wait to check your file when you email it to me. I presum...
Hi Mardi, Can you please email me the file website at myonlinetraininghub.com? The measures screenshot isn't what I meant. I want to see the formul...
Hi Mardi, Please show me the measure formula for Consumption kWh and the row context for the PivotTable so I can understand how the data in the row...
Hi Mardi, Are 'Sum of Consumption kWH' and 'Count of RFIDCard_id' explicit measures? They look like implicit measures to me. Can you please shar...
Well, if there are no conflicts i.e. rows with Types in both columns, I'd merge the columns, otherwise you could use and if statement to create a 3rd ...
Thanks for the example. In future please try and be this explicit when asking questions as it will help get to the answer much quicker. You can cha...
The file I attached achieved your desired result in your original question and shows how to do a merge to bring in the Type information, rather than u...
Yes. The attached file shows how you can use PQ to assign the Type to all rows for a contract based on the data in the Type column, but like I said, I...