Forum Discussion
KPI for blank
BhavyaM
Try this modified measure:_Trend = SWITCH( TRUE(), [_Diff] = 0, UNICHAR(9660), [_Diff] = BLANK(), "", [_Diff] > 0 ,UNICHAR(9650) , [_Diff] < 0 ,UNICHAR(9660) )________________________
Did I answer your question? Mark this post as a solution, this will help others!.
I accept KUDOS 🙂
Thank you very much it help me and working now.
I am facing one issue in Data set refresh time, Can you please help me. this is very urgent requiremnt which i need to fix this soon. I am trying but not getting solution.
I used below Query to show the Last Data reset refresh time.
let
Source=Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("VZDLCQAhDAV78Sxonv9axP7bWLNPMN4mDMYhc7oUBAFRmvNOJBTy8r8RnTpNJh8TdRo0iUzT94BIIeTzRBdAaBr5GF0A0FTyMZqGdNM2mwDkG7CZZuhQKEA2ZdWI+pQ1U9ae/7v5v9vTYNzTYNiyFG/Z5rU+", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [dtDSTStart = _t, dtDSTEnd = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"dtDSTStart", type date}, {"dtDSTEnd", type date}}),
varCurrentDate = DateTime.Date(DateTimeZone.SwitchZone(DateTimeZone.LocalNow(),+4)),
#"Filtered Rows" = Table.SelectRows(#"Changed Type", each [dtDSTStart] < varCurrentDate and [dtDSTEnd] > varCurrentDate),
varDSTOffset = Table.RowCount(#"Filtered Rows"),
#"Last Refresh Date" = #table(
type table
[
#"RefreshDate"=datetimezone
],
{
{DateTimeZone.SwitchZone(DateTimeZone.LocalNow(),+4 + varDSTOffset,0)}
}
)
in
#"Last Refresh Date"
I used below measure
Last Update = "Last Update on " & UNICHAR(10) & FORMAT(MAX('Refresh Time Stamp'[RefreshDate]),"MMM DD, YYYY H:MM AM/PM")
But i am getting 30mins difference. For example, My Data set refresh time is "26/07/2020 8:30pm" and My system date and Time also same but my measure is showing me "26/07/2020 8:00PM".
How to show the date and time as per the Refresh date and time.
Please help me.
Thanks in advance.