Forum Discussion
New table with dates
Hi, I have a database which contains loads of data, with some key columns being used to feed my PBI pages.
one thing I am trying to create is a scatter diagram which looks at active entries in the database, then where they have a delivery date in October for example, plot that on the graph. However I can't get my calculation to work on just active records.
i did wonder if it's easier to have a separate table created which pulls the information into it, then I can use this rather than the main table.
the key columns of data would be
| Unique ID | Status | Delivery Date |
| 1 | Active | 10/10/24 |
| 2 | Active | 10/10/24 |
| 3 | Closed | 10/10/24 |
| 4 | Active | 15/11/24 |
in this example I would expect to plot 2 records in October and 1 in November. The other slight nuisance is the delivery dates will go on into next year too, but ideally my graph would have the current month first.
Hello Danielwood ,
Thanks for your post, I assume you are looking to filter only active records in the Power bI for the sample records you have provided, you can use the measure like this below..
Measure - Calculate(Countrows("Your Table name"), Status = "Active")
Thanks
Dharmendar SIf you find my reply useful please like and mark it as solution.
2 Replies
Hello Danielwood ,
Thanks for your post, I assume you are looking to filter only active records in the Power bI for the sample records you have provided, you can use the measure like this below..
Measure - Calculate(Countrows("Your Table name"), Status = "Active")
Thanks
Dharmendar SIf you find my reply useful please like and mark it as solution.
I actually stumbled upon a fix completely by accident. If I use a line graph rather than scatter, filter the visual to only show active, it worked. Thank you for taking the time to respond
