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.
I have a simple date column in a table in the format below:
10/10/2018
01/02/2017
04/02/2018
How can I arrange these by some custom financial quarter dates?
Q1 | Feb-20 | May-20 |
Q2 | May-21 | Aug-20 |
Q3 | Aug-21 | Nov-20 |
Q4 | Nov-21 | Feb-20 |
Create a calculated column and try to use the following DAX:
Q = "Q"&ROUNDUP(MONTH(IF('US Calendar'[Month]<=7,'US Calendar'[Date]-50,'US Calendar'[Date]-51))/3,0)
Doesnt seem to work, I get :
DAX comparison operations do not support comparing values of type Text with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values.
Did you use the following DAX to change get the number of Month?
Month = MONTH('US Calendar'[Date])
thats it! How does the logic work there? if I wanted to amend to change the dates to:
Q1 | Feb-04 | May-05 |
Q2 | May-06 | Aug-04 |
Q3 | Aug-05 | Nov-03 |
Q4 | Nov-04 | Feb-03 |
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 |
---|---|
118 | |
107 | |
70 | |
70 | |
43 |
User | Count |
---|---|
148 | |
105 | |
104 | |
89 | |
65 |