Thanks Mynda, I'll give that a go. It also occurred to me (while putting on make up this morning - why does the brain do that?) to merge the two ta...
Brilliant, thanks! I had originally done it by making a table from various pivot tables' data but the table couldn't share slicers so all that was get...
Thanks for doing this, it's much appreciated. I've been looking at the DAX formula you used for the measure "Distinct Visits". It's an IF statement...
Brilliant! Thanks Mynda. I spent most of yesterday re-watching a lot of the Power Pivot training videos, which has helped with some other questions I ...
It is, thank you so much!
Done, thanks 🙂
Hi I think it might be easier for both of us if I upload the workbook - I've removed identifying data. I hope this is OK! ETA: That's not g...
Hi Mynda Consumption kWh is Consumption Wh divided by 1000 to add a new column in the query (see attachment). Not sure what the second request mean...
I've worked it out - no need to answer! I right clicked the Values area in the Report and chose New Quick Measure, which brought up a simple dialog...