content

2 Topics

POST request with Power Query fails auth but needs to be Anonymous
The Web.Contents function needs to specify content for making a POST request, but can`t get auth right. I pass the credentials (APIKey) and it works on Postman, but if I do it anonymous in PB it fails saying that can`t verify the credentials, but if I change it to basic auth PB tells me that the query needs to be from anonymous source. The code looks like this, the main part ends at JsonResponse, I don't think that the transformation of data matters for this problem.
Solved
JangoChained
2 years ago Place DAX Commands and Tips
1.3KViews
0likes
2Comments
Retention Rate by level of purchase
Hi, I calculate Retention RateY = DIVIDE([ConstantClientCount],[ActiveClientCountYearAgo]) and display it by different criteria (Departments, Region etc) The client request is to calculate the Retention Rateby by the level of purchase value per customer. Example High ( 25k plus), Medium (5k-10k), Low (5k and less). I added a calculated column in the customer table, which gives the level of each customer by overall average value for the respective customer. The problem is that in real life, a customer can buy one year for 5k, and the next year 10k and then 25k. Therefore, will move yearly between levels: Year 1 could be low, year 2 could be medium and year 3 could be high. The method I used will count the client, all the time, within the same category of purchase determined by the average of all purchases for this client. I need to display the Retention Rate, 5 years evolution, witch consider this client, in different categories of purchase ( if 2020, $25k, high),( if 2021, $2k, low ) Thanks for the advice or link or any other reference.
Solved
AH2022
3 years ago Place DAX Commands and Tips
873Views
0likes
2Comments