Notifications
Clear all
Power BI
5
Posts
2
Users
0
Reactions
183
Views
Topic starter
Hello,
Could you please advise how to create a title by concatenating the "last date" + text? The formula i'm using says i'm using too few arguments.
Thanks.
Posted : 12/06/2024 1:51 am
Let's say the date is in A1 then you could do something like this:
=TEXT(A1, "dd-mm-yyyy") & " text"
If this is not what you had in mind, please clarify your needs.
Posted : 12/06/2024 2:42 am
Topic starter
Hi!
I currently have a measure in PowerBI:
Last Date = LASTDATE('RAW Data'[Date])
I'd like to concatenate this lastdate measure with text, to create a title: "Date to week ending 07/06/2024"
So I tried this (and variations):
title = CONCATENATE("Data to week ending" & ([Last Date]))
Seems to be missing something. Could you please advise?
Many thanks.
Posted : 12/06/2024 10:07 pm
Sorry that I hadn't noticed that you were posting into the Power Bi forum. That explains my 'Excel-answer'.
Change the measure to:
title = CONCATENATE("Data to week ending" , ([Last Date]))
or just to:
title = "Data to week ending" & ([Last Date])
Either should work.
Posted : 13/06/2024 12:56 am
Topic starter
Thank-you. This works. 🙂
Posted : 13/06/2024 1:46 am
