The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I'm some what new at PBI.
I'm trying to figure out how many orders were placed and also filled within each quarter. I do have a slicer for the Quarter on the report. I'm really stumped as to how to go about getting the calculations. Any help would be appreciated.
Order date | Filled Date |
06/08/2023 | 07/26/2023 |
06/09/2023 | 07/24/2023 |
04/27/2023 | 07/20/2023 |
05/24/2023 | 07/10/2023 |
06/01/2023 | 07/03/2023 |
05/25/2023 | 06/20/2023 |
03/08/2023 | 06/15/2023 |
05/01/2023 | 06/15/2023 |
01/24/2023 | 06/09/2023 |
06/08/2023 | 06/08/2023 |
04/05/2023 | 05/31/2023 |
03/28/2023 | 05/24/2023 |
03/14/2023 | 05/16/2023 |
03/02/2023 | 05/08/2023 |
03/01/2023 | 05/03/2023 |
02/06/2023 | 05/01/2023 |
02/17/2023 | 04/28/2023 |
04/20/2023 | 04/27/2023 |
02/25/2023 | 04/27/2023 |
03/30/2023 | 04/18/2023 |
03/16/2023 | 03/30/2023 |
02/21/2023 | 03/16/2023 |
01/31/2023 | 03/10/2023 |
02/09/2023 | 03/10/2023 |
01/12/2023 | 02/17/2023 |
02/08/2023 | 02/08/2023 |
02/07/2023 | 02/07/2023 |
03/02/2023 | |
03/27/2023 | |
04/18/2023 | |
04/20/2023 |
UPDATE
I actually came up with a solution. I created a column for the quarter for order date and another for filled date. Then I added a conditional column to compare the two columns and return a value, 1 if the orders were placed and filled within the same quarter and 0 if they weren't. Then just added the value of the column in the visual. I can't believe how simple the solution was and how much I was over thinking and complicating this.
hi, @Dashboard_Dev
(1)
if your slicer data(quarter no) present with same table then use below code
Thank you, but even when I changed the names to the actual table names there were multiple syntax errors.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
32 | |
20 | |
16 | |
15 |
User | Count |
---|---|
79 | |
32 | |
30 | |
24 | |
21 |