Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, everyone
I have included a measure in my data model that shows last date refresh have been made.
I would like to show in the report something like: 'Last refresh: dd/mm/aaaa hh_mm:ss.'.
I have tried to do that creating a measure: 'Last_Refresh_Concat = CONCATENATE("Last Refresh: ";[Last_Refresh_NoConcat])'
I have created another measure to test: 'Last_Refresh_NoConcat = MAX('Sales'[Last refresh column])'
As you can see below, I can format date with no_concat measure, but I don't know how can I do it with concat_measure.
Any suggestion??
Thanks,
Solved! Go to Solution.
hi, you can use this:
LastRefreshText= "Last Refresh " & FORMAT(Max(Table1[LastRefresh]),"DD/MM/YYYY HH: MM : SS")
No Spaces Between Hours Minutes & Seconds.
hi, you can use this:
LastRefreshText= "Last Refresh " & FORMAT(Max(Table1[LastRefresh]),"DD/MM/YYYY HH: MM : SS")
No Spaces Between Hours Minutes & Seconds.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |