Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a customised string that I want to include the end of the week date (Saturday) from a column I have [Event Date of first case]:
e.g. measure
Title Table 1. = "Table 1: Contains all of my sample data " &
MAXX(ALL('Outbreaks and Events'),'Outbreaks and Events'[Event Date of first case]) &
" = "
& [Outbreak Identifier Count] //& MOD('Outbreaks and Events'[Event Date of first case])
In this case I have used MAXX(ALL('Outbreaks and Events'),'Outbreaks and Events'[Event Date of first case] to find the max of [Event Date of first case] but this goes too far and I need to just find the END OF THE WEEK (Saturday) for this column
Can this be done?
Thanks in advance
Maybe something like FORMAT(MOD)????
Solved! Go to Solution.
If this is for a calculated column, this expression can be adapted to get the end of the week (Saturday) date on each row. You can concatenate it into your expression.
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
If this is for a calculated column, this expression can be adapted to get the end of the week (Saturday) date on each row. You can concatenate it into your expression.
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Can you share some sample data and the expected result to have a clear understanding of your question?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?
_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |