Forum Discussion
Standard Deviation calculations returning Wrong Numbers
Hi I have some simple data which contains date, visits and bookings. From this I calculate conversion rate (bookings/visits) and then from this I measure a day on day and week on week conversion ...
Hi Troops ,
Your two links are all xlsx files. I think you want the value displayed in the Power BI. You can download my test file and refer to it.
Hi
Thanks for the response. I was able to adapt the formulas used here for my report. Essentially mine wasn't working (I think) due to my DoD/WoW being custom metrics rather than custom columns.
Now I need to adapt further I think. In my actual data I have other columns e.g. device so that each date will now have 2 rows and the user can use a filter to pick device.
Will this logic still work? I'm thinking some of the custom columns you've created wouldn't work due to the index (i.e multiple rows with the same index).