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,
I have a text col 'Custom' & a decimal measure 'Last 8 Wks Offered'
What I'm trying to return is that if 'Custom' = "Carer" then 'Last 8 Wks Offered' = "N/A" else 'Last 8 Weeks Offered"
Solved! Go to Solution.
@Qotsa
It's not possible to have different data-types in one column, you change the else part to text by modifying your formula as follows:
Test =
IF (
Append1[Custom] = "Carer",
FORMAT ( [Last 8 Wks Offered], BLANK (), "en-GB" ),
FORMAT ( [Last 8 Wks Offered] , "#,0.00")
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
You can do something within the measure- [Last 8 Wks Offered] like:
DAX Measure =
var selectedcustom = SelectedValue(Append1[Custom] )
return
IF(selectedcustom = "Carer",BLANK(),<logic to get [Last 8 Wks Offered]>)
You can do something within the measure- [Last 8 Wks Offered] like:
DAX Measure =
var selectedcustom = SelectedValue(Append1[Custom] )
return
IF(selectedcustom = "Carer",BLANK(),<logic to get [Last 8 Wks Offered]>)
@Qotsa
It's not possible to have different data-types in one column, you change the else part to text by modifying your formula as follows:
Test =
IF (
Append1[Custom] = "Carer",
FORMAT ( [Last 8 Wks Offered], BLANK (), "en-GB" ),
FORMAT ( [Last 8 Wks Offered] , "#,0.00")
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |