Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I have two dates as created date and closed date.
sample data as below,
Created Date | Closed Date |
20 February 2019 | 2 March 2019 |
21 February 2019 | 10 March 2019 |
1 March 2020 | 4 April 2020 |
1 January 2021 | 2 February 2021 |
10 January 2021 | 23 February 2021 |
2 February 2021 | 5 March 2021 |
I calculated count of each month by year as below,
Created Date | Closed Date | Created Date Count | Closed Date Count |
20 February 2019 | 2 March 2019 | 2 | 2 |
21 February 2019 | 10 March 2019 | 2 | 2 |
1 March 2020 | 4 April 2020 | 1 | 1 |
1 January 2021 | 2 February 2021 | 2 | 2 |
10 January 2021 | 23 February 2021 | 2 | 2 |
10 Februray 2021 | 23 March 2021 | 1 | 1 |
When I'm trying to create graph, I am passing Created Date and Closed Date in Axis and in Values i'm passing created date count, closed date count, but on graph not showing the correct count because i'm passing 2 different date's in Axis.
I have tried using Calendar table also but while creating relationship it giving me an error: Circular dependancy was detected.
Is there any other way to do it, without using UseRelationship Function.
@amitchandak is it possible to do this without creating Active or inactive relationships?
@VD , Try with an independent Table
Created =
var _min = minx(allselected(Date), Date[Date])
var _max = maxx(allselected(Date), Date[Date] )
return
calculate(sum(Table[Value]), filter(Table, Table[Created Date] <=_max && Table[Created Date] >=_min))
Closed =
var _min = minx(allselected(Date), Date[Date])
var _max = maxx(allselected(Date), Date[Date] )
return
calculate(sum(Table[Value]), filter(Table, Table[Closed Date] <=_max && Table[Created Date] >=_min))
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
9 | |
8 | |
6 | |
5 |
User | Count |
---|---|
19 | |
17 | |
12 | |
9 | |
9 |