- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Expression in DAX
Hi All,
I need to write this expression in DAX. Please help me
=if(responsetype like '*%' and not MaxDate like '*%',text(MaxDate & '%'),text(MaxDate))
Response Type | Max date |
###,###,###,##0 | 99 |
###,###,###,##0.00 | 22 |
###,###,###,##0.00% | text value (ss)
|
None | * |
if response type value is "*" and max date is not "*" than it should display text(MaxDate & '%' )
else text (maxdate)
Thanks
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Kavya123
You can use the following DAX expression:
= IF(AND(SEARCH("%", [Response Type]) > 0, NOT(SEARCH("%", [Max date]) > 0)), CONCATENATE([Max date], "%"), [Max date])
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Kavya123
You can use the following DAX expression:
= IF(AND(SEARCH("%", [Response Type]) > 0, NOT(SEARCH("%", [Max date]) > 0)), CONCATENATE([Max date], "%"), [Max date])
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
Subject | Author | Posted | |
---|---|---|---|
11-25-2024 07:30 PM | |||
06-25-2024 09:52 AM | |||
07-08-2024 05:08 PM | |||
03-24-2024 03:46 PM | |||
07-22-2024 04:33 AM |
User | Count |
---|---|
6 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
10 | |
2 | |
2 | |
2 | |
2 |