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 column with values of Non-Covid and Covid. If the value is Covid, the fiscal year needs to be formatted and populated based on the Scheduled Start column. If the value is Non-Covid, the fiscal year needs to be formatted and populated based on the Reported Date column. My formula is
Solved! Go to Solution.
If this is a calculated column in a table, try:
Fiscal Month/Yr = IF(
'2700 WO Listing'[Covid vs Non-Covid (groups)]="Non-Covid",
FORMAT('2700 WO Listing'[Reported Date],"MMM-yyyy"),
FORMAT('2700 WO Listing'[Scheduled Start],"MMM-yyyy")
)
If you are using this in a measure, try:
Fiscal Month/Yr = IF(
MAX( '2700 WO Listing'[Covid vs Non-Covid (groups)]) = "Non-Covid",
FORMAT('2700 WO Listing'[Reported Date],"MMM-yyyy"),
FORMAT('2700 WO Listing'[Scheduled Start],"MMM-yyyy")
)
Proud to be a Super User!
Paul on Linkedin.
@ahhollan this syntax should work for calculated column:
but it would not work for a measure.
also, the way you have it written will make it a text column. You could also remove the format() from each part and just return each them as dates, then format the column into the desired format if you want it to still behave as a date column.
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
you lost some parentheses, formulas and quotation marks. Try this:
Fiscal Month/Yr =
IF (
'2700 WO Listing'[Covid vs Non-Covid (groups)] = "Non-Covid",
FORMAT ( '2700 WO Listing'[Reported Date], "MMM-yyyy" ),
FORMAT ( '2700 WO Listing'[Scheduled Start], "MMM-yyyy" )
)
Proud to be a Super User. If I helped, please accept the solution and give kudos! |
If this is a calculated column in a table, try:
Fiscal Month/Yr = IF(
'2700 WO Listing'[Covid vs Non-Covid (groups)]="Non-Covid",
FORMAT('2700 WO Listing'[Reported Date],"MMM-yyyy"),
FORMAT('2700 WO Listing'[Scheduled Start],"MMM-yyyy")
)
If you are using this in a measure, try:
Fiscal Month/Yr = IF(
MAX( '2700 WO Listing'[Covid vs Non-Covid (groups)]) = "Non-Covid",
FORMAT('2700 WO Listing'[Reported Date],"MMM-yyyy"),
FORMAT('2700 WO Listing'[Scheduled Start],"MMM-yyyy")
)
Proud to be a Super User!
Paul on Linkedin.
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 |
---|---|
97 | |
97 | |
82 | |
75 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |