Hi everyone, I'm trying to get data from hubspot API to powerbi using a POST method. I'm using this code to get the data but for some reason i'm receiving this error: We canno...
Hello, all! I have the following table And im trying to get a simple DISTINCT COUNT[ID] but its not working because the column Type has two different values (B and E). If i use a...
Hello there I am actually working with Callcenter-Data. I need help to create measures returning ... the name of the CC-Agent with the Max Number of Calls per week ... the name of the CC-Agent wi...
I have a list with unique system ID's who require periodic Preventive Maintenance. I would like to know whether for that same system ID there has been a Corrective Maintenance within one month after ...
Hello all! I have a DAX formula in place for calculating NPS score based on information that customers provide. I need to add some logic to make sure that NPS is only calculated once per cus...
I have a large amount of data with a lot of different work centers, but I want to calculate workcenter1(good parts/total parts) * workcenter2(good parts/total parts) * ... but only for a certain list...
I have created two measure current year sales and previous year Sales and I have year Slicer I have created table Customer wise current year and previous year sales What I want is&n...
i am calculating a formula where CurrentAmount / (CurrentAmount + NextAmount) * 1000000 example: 0.1/(0.1+59.9)*1000000 =1666.66 the below fomula works fine if i just download the da...
Hi All, i am calculating a formula where CurrentAmount / (CurrentAmount + NextAmount) * 1000000 example: 0.1/(0.1+59.9)*1000000 =1666.66 the test column formula is :...