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.
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!
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |