March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi Guys,
I have finally created a calendar table that is aligned with my organizations Fiscal Year.
Huge shout-out to @amitchandak for helping with that task.
Now I would like to create a column that would represent a Month Period.
Our months in the organization are split in to 2 periods.
1st Period runs from the 1st of the month until 15th of the month.
2nd Period runs from the 16th of the month until end of that month.
for example:
01.01.2020 - 15.01.2020 = January, Period 1
16.01.2020 - 31.01.2020 = January, Period 2
01.02.2020 - 15.02.2020 = February, Period 1
16.02.2020 - 29.02.2020 = February, Period 2
I was wondering if there is a way to create a column in my calendar that would split the months in to these periods?
I would like for the column to be represented as such:
Reporting Period
February P1
February P2
March P1
March P2
April P1
April P2
etc.
My Fiscal Year Starts on 1st of September and Ends on 31st of August (If that helps)
My Current Calendar Table:
Best Regards,
Kris
Solved! Go to Solution.
Hi @TapZxK
try to create a calculated column
Reporting Period =
var _period = IF(DAY('CalendarTable'[Date])<16," P1"," P2")
RETURN
CONCATENATE(FORMAT(CalendarTable[Date],"mmmm"),_period)
do not hesitate to give a kudo to useful posts and mark solutions as solution
Hi @TapZxK
try to create a calculated column
Reporting Period =
var _period = IF(DAY('CalendarTable'[Date])<16," P1"," P2")
RETURN
CONCATENATE(FORMAT(CalendarTable[Date],"mmmm"),_period)
do not hesitate to give a kudo to useful posts and mark solutions as solution
Hi @az38,
Worked like a charm.
Thank you very much.
When I think about the logic behind this DAX it's actualy very simple.
It's just knowing how to express this logic in DAX that is what's challenging for me at the moment.
Much appreciated.
BR,
Kris
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
93 | |
87 | |
84 | |
77 | |
49 |
User | Count |
---|---|
163 | |
148 | |
103 | |
74 | |
55 |