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.
Dear community
Is it possible for a YearMont column to be a date format? So basically I'm trying to create a financial yearmonth field from the calendar but I'm not getting it right. It creates successfully as below but I'm struggling to convert it to a date format so that I create the column with this format "mmm-yyyy", e.g. Jan - 2020.
Below is the DAX I used to create the column, I even used the Format function and I'm still not getting the results I want. I've tried changing the column to Text then Date, it gives me an error. Since this is from a calendar created within the report, I can't use Transform data option.
Please assist.
Thank you
Matlotlo
Solved! Go to Solution.
If I understood your logic correctly, then this should help
FinYearMonth =
VAR FiscalStartMonth = 7
VAR FinYearMonth = If( MONTH([Date]) > (FiscalStartMonth - 1),
DATE((YEAR([Date])+1),MONTH([Date]),DAY([Date])),
DATE(YEAR([Date]),MONTH([Date]),DAY([Date])))
RETURN
FORMAT(FinYearMonth, "mmmm-yyyy")
I hope this helps.
Regards
Kumail Raza
If I understood your logic correctly, then this should help
FinYearMonth =
VAR FiscalStartMonth = 7
VAR FinYearMonth = If( MONTH([Date]) > (FiscalStartMonth - 1),
DATE((YEAR([Date])+1),MONTH([Date]),DAY([Date])),
DATE(YEAR([Date]),MONTH([Date]),DAY([Date])))
RETURN
FORMAT(FinYearMonth, "mmmm-yyyy")
I hope this helps.
Regards
Kumail Raza
Hello @Tlotly
If you could send sample .pbix that demonstrate what you are looking to get. It would really help providing you a quick solution.
Regards
Kumail Raza
@Tlotly , if you have date , you can do it using format
format([Date], "mmm -yyyy")
@amitchandak the only date I have is a calendar date, hence I'm trying to create Fiscal date but with mmm-yyyy format. My fiscal dates are from Jul - Jun.
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 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |