Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Community,
Woould you please help me to determine how to create column that can Identify Current fiscal Quater. I have tried with this formula but it is not working. ( I am donot have dates table)
Due Date (M/D/Y) | Current Quarter |
01/19/2023 | Q1 |
10/31/2022 | Q1 |
11/22/2022 | Q1 |
12/15/2022 | Q1 |
02/17/2023 | |
07/18/2023 | |
09/18/2023 | |
10/25/2023 | |
11/14/2023 |
Solved! Go to Solution.
They've also recently released custom templates:
https://www.sqlbi.com/articles/customizing-date-and-time-intelligence-templates-in-bravo-for-power-b...
@sam_hoccane, I'd strongly recommend using a date table.
https://radacad.com/do-you-need-a-date-dimension
One way to define your fiscal quarter:
ROUNDDOWN ( MOD ( MONTH ( [Date] ) + 1 , 12 ) / 3, 0 ) + 1
Definitely agree on adding a Date table. Either way, you can easily create your FQ column with an expression like this:
FQ = "Q" & QUARTER(EOMONTH(Table[DueDate], 2))
Replace Table[DueDate] with your actual Table[Column]
Pat
Nice! Much cleaner than what I proposed.
Hi @sam_hoccane ,
I would recommend using a date table like the one below which you can adjust to fit your fiscal calendar:
https://www.sqlbi.com/articles/reference-date-table-in-dax-and-power-bi/
They've also recently released custom templates:
https://www.sqlbi.com/articles/customizing-date-and-time-intelligence-templates-in-bravo-for-power-b...
@sam_hoccane, I'd strongly recommend using a date table.
https://radacad.com/do-you-need-a-date-dimension
One way to define your fiscal quarter:
ROUNDDOWN ( MOD ( MONTH ( [Date] ) + 1 , 12 ) / 3, 0 ) + 1
Thankyou all!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |