The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
attached data sample here
ColumnA |
10/5/2022 5:35:52 PM, abcdefghijklmnopqrstuvwxyz |
10/2/2022 9:41:39 PM, abcdefghijklmnopqrstuvwxyz |
9/23/2022 6:35:33 PM, abcdefghijklmnopqrstuvwxyz |
9/22/2022 10:39:04 PM, abcdefghijklmnopqrstuvwxyz |
9/22/2022 10:38:49 PM, abcdefghijklmnopqrstuvwxyz |
9/22/2022 6:34:23 PM, abcdefghijklmnopqrstuvwxyz |
9/22/2022 6:00:00 PM, abcdefghijklmnopqrstuvwxyz |
9/3/2022 4:32:16 PM, abcdefghijklmnopqrstuvwxyz |
8/22/2022 6:16:21 PM, abcdefghijklmnopqrstuvwxyz |
10/5/2022 5:35:52 PM, abcdefghijklmnopqrstuvwxyz |
10/2/2022 9:41:39 PM, abcdefghijklmnopqrstuvwxyz |
9/23/2022 6:35:33 PM, abcdefghijklmnopqrstuvwxyz |
9/22/2022 10:39:04 PM, abcdefghijklmnopqrstuvwxyz |
9/22/2022 10:38:49 PM, abcdefghijklmnopqrstuvwxyz |
9/22/2022 6:34:23 PM, abcdefghijklmnopqrstuvwxyz |
9/22/2022 6:00:00 PM, abcdefghijklmnopqrstuvwxyz |
9/3/2022 4:32:16 PM, abcdefghijklmnopqrstuvwxyz |
8/22/2022 6:16:21 PM, abcdefghijklmnopqrstuvwxyz |
4/18/2022 7:00:00 PM, abcdefghijklmnopqrstuvwxyz |
Solved! Go to Solution.
Hi @KSPG,
Even though this can be a lot simpler task in Power Query, since you have asked in DAX, here you go. Create two new columns, one for Date and another for Text based on the position of the comma.
Date = LEFT('Table'[Message],SEARCH(",",'Table'[Message])-1)
Text = MID('Table'[Message],SEARCH(",",'Table'[Message])+2,LEN('Table'[Message]))
Now create this measure and add it in a card visual:
Latest Message = CALCULATE(MAX('Table'[Text]),FILTER('Table','Table'[Date]=MAX('Table'[Date])))
Works for you? Mark this post as a solution if it does!
Consider taking a look at my blog: Forecast Period - Graphical Comparison
Hi @KSPG,
Even though this can be a lot simpler task in Power Query, since you have asked in DAX, here you go. Create two new columns, one for Date and another for Text based on the position of the comma.
Date = LEFT('Table'[Message],SEARCH(",",'Table'[Message])-1)
Text = MID('Table'[Message],SEARCH(",",'Table'[Message])+2,LEN('Table'[Message]))
Now create this measure and add it in a card visual:
Latest Message = CALCULATE(MAX('Table'[Text]),FILTER('Table','Table'[Date]=MAX('Table'[Date])))
Works for you? Mark this post as a solution if it does!
Consider taking a look at my blog: Forecast Period - Graphical Comparison
User | Count |
---|---|
27 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
31 | |
15 | |
12 | |
11 | |
7 |