Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm new at Power BI, so got a lot of questions - please bear with me I need a measure that will show we the count of open cases by end of each month
DCount_EndOfMonth
CALCULATE (
DISTINCTCOUNT ( P_A_ALL[item no.]);
FILTER(P_A_ALL;P_A_ALL[item status]<>"closed")
)
this obviously doesnt work, i need to add a date field as well, my question is how do i do that, the date field is created date
the result should be e.g. end of januar 2016 open items 60, end of february 48, end of march 142 etc. ...
Solved! Go to Solution.
Hi @Anonymous,
Suppose your data table is like below. Add two calculated columns using following formulas:
MonthName = P_A_ALL[created date].[Month]
Column = IF(P_A_ALL[item status]="close",1,0)
Then, modify your measure as :
DCount_EndOfMonth =
CALCULATE ( SUM ( P_A_ALL[Column] ), ALLEXCEPT ( P_A_ALL, P_A_ALL[MonthName] ) )
If you have any other question, please feel free to ask.
Best regards,
Yuliana Gu
thank you
This is the result i get,
I created the 2 columns and created the measure and added to the chart as line value - unfortunatly this isnt how it should look
So in your eaxample
End of January the number of open cases should be 1, february 3+the one from January = 4 and so on
and this is what i want to show in the line value
Is it not possible to attach a pbix file ?
You can upload a file to dropbox, onedrive or another similar and share the link
User | Count |
---|---|
107 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |