Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey guys,
i try to solve my problem since 2 days...
I have a table "login" with 2 Colums:
[id] and [date]
I Created a Extra Table "calendar" with all dates from the 01.01.2017 to the 30.07.2017.
Now i tryed to get a new colum in "calendar" [ID count]. This Colum should show me how many id's from "login" logged in per day.
can someone help me?
Thank you
RTW-93
Solved! Go to Solution.
Hi @RTW93,
as a best practice you should use a measure and then apply it based on context because columns only add to your model, and if one expression can change into a measure do it instead of a column, but the syntax for the new colum in calendar table sould be one of this two:
Count per day = CALCULATE(COUNT(Login[ID]), RELATEDTABLE(Login)) Count per day = COUNTROWS(RELATEDTABLE(Login))
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @RTW93,
You don't need to create a new column if you add the date column (from calendar table) and the ID and select summarize count it will give you the expected result be aware that you need to have both tables related.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHey MFelix,
thanks for your answer, but i need the Colum saved in the table (using table/new Colum). Based on it i need to calculate some other things...
Hi @RTW93,
as a best practice you should use a measure and then apply it based on context because columns only add to your model, and if one expression can change into a measure do it instead of a column, but the syntax for the new colum in calendar table sould be one of this two:
Count per day = CALCULATE(COUNT(Login[ID]), RELATEDTABLE(Login)) Count per day = COUNTROWS(RELATEDTABLE(Login))
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @MFelix, I have bit similar problem but in my case I have one more column of True/False and I want to take only true rows..How could I do this. Could you please address.
Hi @anandsonar1 ,
Can you please share a sample data and expected result.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThanks again,
if i use your Solutions i get on every day 3603 (the count of all rows).
You need to relate both tables to use this formulas.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |