Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have a table, 'Risks'.
In this table I have a column, 'Date', which gives a range of dates across 2018.
I also have a second column, 'Type', which gives the type of event associated with that date. The values are either 'Open' or 'Closed'.
I want to create a measure that calculates how many 'Open' events occured since a fixed date '01/01/2018' and Today.
I have tried to create this measure but have had no luck. Does anyone have any ideas?
Thanks
Solved! Go to Solution.
Try something like this:
OpenEvents = CALCULATE ( COUNTA ( Table1[Type] ), Table1[Date] >= DATE ( 2018, 1, 1 ), Table1[Date] <= TODAY (), Table1[Type] = "Open" )
@shaunguyver - Hi
Please create a Calendar Table and relate it to your Risks Table
Then try this measure
Instances =
CALCULATE (
COUNT ( Risks[Date] ),
DATESBETWEEN ( Calendar[Date], DATE ( 2018, 1, 1 ), TODAY () ),
Risks[Type] = "Open"
)
If you would like to have a unique count of the date then replace the COUNT with DISTINCTCOUNT
Hope this helps
Try something like this:
OpenEvents = CALCULATE ( COUNTA ( Table1[Type] ), Table1[Date] >= DATE ( 2018, 1, 1 ), Table1[Date] <= TODAY (), Table1[Type] = "Open" )
Hi lets try.
MEASURE =
calculate(count(Table[Type]),datesbetween(table[Date],01/01/2018,today())
If it solve please mark as solved and give me your positive feed back.
User | Count |
---|---|
143 | |
71 | |
69 | |
53 | |
52 |
User | Count |
---|---|
208 | |
94 | |
64 | |
60 | |
57 |