Forum Discussion
PreviousMonth Name to Display in Texbox
Hi all,
I would like to display PreviousMonth name by comparing Today() currentmonth-1.
Thanks,
Vijay.
Hi Thanks Remi,
this works fine but thing is i would like to add this as a Dynamic text into my text box.
so i created this (Previous month = FORMAT(DATE("2000";MONTH(TODAY())-1;"01");"mmmm") as mesure
and tried to put in text box but it is not taking,but when i keep in Card it is working.
my actual requirement is to Display "January2017 Month Leaves" bold text along other text i want display in text box.
my query here is Can't we Display Measure along some Static Text in Text box.
Hi Anonymous,
As you know, textbox only supports static text content, we are not allowed to add a measure into it.
To work around your requirement, you can append the static text to the dynamic Month value in measure and display it in Card visual. However, the limitation is that we cannot set "January2017" and "Month Leaves" to different font formats.
The measure could be:
Previous month = FORMAT(DATE("2000";MONTH(TODAY())-1;"01");"mmmm") & " Month Leaves"Alternatively, you can use a Card to display dynamic Month value and use Text box to display static text. Adjust the position of Card to make it locate inside the Textbox so that the text looks like a entirety.
Regards,
Yuliana Gu
8 Replies
Hello.
You can do this by creating an empty Query.
Go to Edit Query --> New Source --> Blank Query --> Paste the following code into the field --> name your Query (Should be Query1 by default).
= Text.Proper(Date.MonthName((Date.AddMonths(DateTime.Date(DateTime.LocalNow()), -1))))
Now you sould see a field named "Previuos Month" with previous months name.
Thank you so much this worked for me
RémiResolver III
Hello,
You have to get the current month from the Today() function, then display the name of previous month :
Previous month = FORMAT(DATE("2000";MONTH(TODAY())-1;"01");"mmmm")
It works for all month, I checked January ;)
Hi Thanks Remi,
this works fine but thing is i would like to add this as a Dynamic text into my text box.
so i created this (Previous month = FORMAT(DATE("2000";MONTH(TODAY())-1;"01");"mmmm") as mesure
and tried to put in text box but it is not taking,but when i keep in Card it is working.
my actual requirement is to Display "January2017 Month Leaves" bold text along other text i want display in text box.
my query here is Can't we Display Measure along some Static Text in Text box.
v-yulgu-msftMicrosoft Employee
Hi Anonymous,
As you know, textbox only supports static text content, we are not allowed to add a measure into it.
To work around your requirement, you can append the static text to the dynamic Month value in measure and display it in Card visual. However, the limitation is that we cannot set "January2017" and "Month Leaves" to different font formats.
The measure could be:
Previous month = FORMAT(DATE("2000";MONTH(TODAY())-1;"01");"mmmm") & " Month Leaves"Alternatively, you can use a Card to display dynamic Month value and use Text box to display static text. Adjust the position of Card to make it locate inside the Textbox so that the text looks like a entirety.
Regards,
Yuliana Gu
