How to retrieve active users in Power BIIterate through API and extract fields in Power Query in Power BIShare Power BI Datasets with Users Outside OrganisationPowerBI new Embedding FeaturesExcept DAX query (or other)Embedding report for power bi userHow to activate a filter by default on Power BI?How to hide a visualization depending on user in power BI?How to calculate Earned Premium between two dates till @AsOfDate and break it down by each month in DAXHow to activate Scheduled refresh in Power BiPower BI - Stale data showing for one user
"I will not" or "I don't" as an answer for negative orders?
Selection Sort Algorithm (Python)
Can I build a half bath without permits?
What in my code changed between MacTeX 2017 and MacTex 2019?
Garage door sticks on a bolt
Detail vs. filler
French license plates
Is population size a parameter, or sample size a statistic?
Do interval ratios take overtones into account or solely the fundamental frequency?
Looking for circuit board material that can be dissolved
Pushing the e-pawn
Is determiner 'a' needed in "one would call such a value a constant"?
What was Han searching through when he found where Lando was?
My machine, client installed VPN,
A word that refers to saying something in an attempt to anger or embarrass someone into doing something that they don’t want to do?
An impressive body of work
As a team leader is it appropriate to bring in fundraiser candy?
I reverse the source code, you reverse the input!
How life stories turned into Halachot - Mishnaic examples?
How deep is the liquid in a half-full hemisphere?
Received a package but didn't order it
Sci-fi movie with one survivor and an organism(?) recreating his memories
Can a passenger predict that an airline is about to go bankrupt?
GPLv3 forces us to make code available, but to who?
How to retrieve active users in Power BI
Iterate through API and extract fields in Power Query in Power BIShare Power BI Datasets with Users Outside OrganisationPowerBI new Embedding FeaturesExcept DAX query (or other)Embedding report for power bi userHow to activate a filter by default on Power BI?How to hide a visualization depending on user in power BI?How to calculate Earned Premium between two dates till @AsOfDate and break it down by each month in DAXHow to activate Scheduled refresh in Power BiPower BI - Stale data showing for one user
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
Very new to Power Bi, sorry for that.
I think I could sort this out with some sql, but would really like to give it a try with Power Bi.
What I have is a usage table. When a customer first uses the service it becomes active and is considered active until it turns of the service and gets a "end_date" Since the service is not used very often it does not get a use_date for every month and I can not therefor get a return as an active user on, in this example, mars and april.
Also i need some query logic to understand that when there has been an end_date, the customer is inactive until it starts to use the service again, and from that point is active again.
Any help would be much appreciated.
Example data
custid,use_date,end_date
123,2015-01-23,
123,2015-02-20,
123,2015-07-14,2015-07-14
123,2015-09-20,
123,2015-11-20,
332,2015-01-20,
332,2015-05-15,2015-05-15
332,2015-10-14,
332,2015-11-20,
Prefered output
Month,Active_customers
2015-01,2
2015-02,2
2015-03,2
2015-04,2
2015-05,1
2015-06,1
2015-07,0
2015-08,0
2015-09,1
2015-10,2
2015-11,2
Prefered output
Month,Active_customers
2015-01,2
2015-02,2
2015-03,2
2015-04,2
2015-05,1
2015-06,1
2015-07,0
2015-08,0
2015-09,1
2015-10,2
2015-11,2
powerbi
edited Mar 29 at 0:30
Nik
1,2047 silver badges17 bronze badges
asked Mar 28 at 19:22
oostoost
12 bronze badges
add a comment
|
Very new to Power Bi, sorry for that.
I think I could sort this out with some sql, but would really like to give it a try with Power Bi.
What I have is a usage table. When a customer first uses the service it becomes active and is considered active until it turns of the service and gets a "end_date" Since the service is not used very often it does not get a use_date for every month and I can not therefor get a return as an active user on, in this example, mars and april.
Also i need some query logic to understand that when there has been an end_date, the customer is inactive until it starts to use the service again, and from that point is active again.
Any help would be much appreciated.
Example data
custid,use_date,end_date
123,2015-01-23,
123,2015-02-20,
123,2015-07-14,2015-07-14
123,2015-09-20,
123,2015-11-20,
332,2015-01-20,
332,2015-05-15,2015-05-15
332,2015-10-14,
332,2015-11-20,
Prefered output
Month,Active_customers
2015-01,2
2015-02,2
2015-03,2
2015-04,2
2015-05,1
2015-06,1
2015-07,0
2015-08,0
2015-09,1
2015-10,2
2015-11,2
Prefered output
Month,Active_customers
2015-01,2
2015-02,2
2015-03,2
2015-04,2
2015-05,1
2015-06,1
2015-07,0
2015-08,0
2015-09,1
2015-10,2
2015-11,2
powerbi
edited Mar 29 at 0:30
Nik
1,2047 silver badges17 bronze badges
asked Mar 28 at 19:22
oostoost
12 bronze badges
add a comment
|
Very new to Power Bi, sorry for that.
I think I could sort this out with some sql, but would really like to give it a try with Power Bi.
What I have is a usage table. When a customer first uses the service it becomes active and is considered active until it turns of the service and gets a "end_date" Since the service is not used very often it does not get a use_date for every month and I can not therefor get a return as an active user on, in this example, mars and april.
Also i need some query logic to understand that when there has been an end_date, the customer is inactive until it starts to use the service again, and from that point is active again.
Any help would be much appreciated.
Example data
custid,use_date,end_date
123,2015-01-23,
123,2015-02-20,
123,2015-07-14,2015-07-14
123,2015-09-20,
123,2015-11-20,
332,2015-01-20,
332,2015-05-15,2015-05-15
332,2015-10-14,
332,2015-11-20,
Prefered output
Month,Active_customers
2015-01,2
2015-02,2
2015-03,2
2015-04,2
2015-05,1
2015-06,1
2015-07,0
2015-08,0
2015-09,1
2015-10,2
2015-11,2
Prefered output
Month,Active_customers
2015-01,2
2015-02,2
2015-03,2
2015-04,2
2015-05,1
2015-06,1
2015-07,0
2015-08,0
2015-09,1
2015-10,2
2015-11,2
powerbi
edited Mar 29 at 0:30
Nik
1,2047 silver badges17 bronze badges
asked Mar 28 at 19:22
oostoost
12 bronze badges
Very new to Power Bi, sorry for that.
I think I could sort this out with some sql, but would really like to give it a try with Power Bi.
What I have is a usage table. When a customer first uses the service it becomes active and is considered active until it turns of the service and gets a "end_date" Since the service is not used very often it does not get a use_date for every month and I can not therefor get a return as an active user on, in this example, mars and april.
Also i need some query logic to understand that when there has been an end_date, the customer is inactive until it starts to use the service again, and from that point is active again.
Any help would be much appreciated.
Example data
custid,use_date,end_date
123,2015-01-23,
123,2015-02-20,
123,2015-07-14,2015-07-14
123,2015-09-20,
123,2015-11-20,
332,2015-01-20,
332,2015-05-15,2015-05-15
332,2015-10-14,
332,2015-11-20,
Prefered output
Month,Active_customers
2015-01,2
2015-02,2
2015-03,2
2015-04,2
2015-05,1
2015-06,1
2015-07,0
2015-08,0
2015-09,1
2015-10,2
2015-11,2
Prefered output
Month,Active_customers
2015-01,2
2015-02,2
2015-03,2
2015-04,2
2015-05,1
2015-06,1
2015-07,0
2015-08,0
2015-09,1
2015-10,2
2015-11,2
powerbi
powerbi
edited Mar 29 at 0:30
Nik
1,2047 silver badges17 bronze badges
asked Mar 28 at 19:22
oostoost
12 bronze badges
edited Mar 29 at 0:30
Nik
1,2047 silver badges17 bronze badges
asked Mar 28 at 19:22
oostoost
12 bronze badges
edited Mar 29 at 0:30
Nik
1,2047 silver badges17 bronze badges
edited Mar 29 at 0:30
Nik
1,2047 silver badges17 bronze badges
edited Mar 29 at 0:30
Nik
1,2047 silver badges17 bronze badges
1,2047 silver badges17 bronze badges
asked Mar 28 at 19:22
oostoost
12 bronze badges
asked Mar 28 at 19:22
oostoost
12 bronze badges
asked Mar 28 at 19:22
oostoost
12 bronze badges
12 bronze badges
add a comment
|
add a comment
|
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/4.0/"u003ecc by-sa 4.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55405400%2fhow-to-retrieve-active-users-in-power-bi%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55405400%2fhow-to-retrieve-active-users-in-power-bi%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
