Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Hi everybody,
I have two columns in my table:
ReportingYear
ReportingPeriod
Is is possible to add a custom column to combine the two to show an actual date? The day can be the first of the month. So for example when the year is 2022 and the reporting period is 5 I would like it to show:
1-5-2022
1 = day
5 = month
2022 = year
I tried a number of things, but I keep getting errors.
Solved! Go to Solution.
Hi @lekkerbek ,
Plese try the below:
Thank you!
In case it answered your question, please accept it as a solution.
Appreciate Your Kudos.
Hi @lekkerbek ,
Plese try the below:
Thank you!
In case it answered your question, please accept it as a solution.
Appreciate Your Kudos.
Why do I always overcomplicate things.
Thank you. You are a star!
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 22 | |
| 22 | |
| 18 | |
| 17 | |
| 13 |
| User | Count |
|---|---|
| 63 | |
| 50 | |
| 46 | |
| 41 | |
| 39 |