Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi Team,
Can you suggest with DAX calculation on How to calculate Product status based on Reporting period and which method would be the best to start.
Below are the logic details how want to calculate a Product details -
Reporting Period Details are-
Reporting Period | Quarter | |
Jan Month Start -Mar Month End | 01-01 to 31-03 | Q1 |
April Month Start -June Month End | 01-04 to 31-05 | Q2 |
July Month Start -Sep Month End | 01-07 to 31-09 | Q3 |
Oct Month Start -Dec Month End | 01-10 to 31-12 | Q4 |
I'm attaching sample data in PBIX file.
Your period table has an error, should say June 30, not May 31, and September 30, not September 31.
Your sample data only has one product ID.
On the first row the Start date is after the end date?
Note that if you include dates that are way in the past (second row) you are artificially inflating the storage memory requirements
Which of the dates should be used for the calculation? The end date or the completion date?
Any particular reason for not using a Calendar/Dates table?
Hey @lbendlin ,
Thanks for the reply
Here is the reporting period re-vamp details -
Reporting Period | Quarter | |
Jan Month Start -Mar Month End | 01-01 to 31-03 | Q1 |
April Month Start -June Month End | 01-04 to 30-05 | Q2 |
July Month Start -Sep Month End | 01-07 to 30-09 | Q3 |
Oct Month Start -Dec Month End | 01-10 to 31-12 | Q4 |
Any particular reason for not using a Calendar/Dates table?
To answer to your question, We dont have Calender tables based on reporting period, If you could share this problem with DAX using Calender table and this approach is best then its fine.
Here is the update data with PBIX file -
Thanks
Hi All,
I will trying to calculate this, can anyone suggest best method Please
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
14 | |
11 | |
7 |
User | Count |
---|---|
26 | |
24 | |
12 | |
11 | |
10 |