How to display current date and time in power bi visuals?

powerbi powerbi-desktop powerbi-custom-visuals
aravind picture aravind · Apr 14, 2019 · Viewed 9.4k times · Source

Is it possible to add a card in power BI that shows the current date and tome time??

Many thanks!

Answer

Alexander Chernov picture Alexander Chernov · Apr 14, 2019

You can show only time of last data refresh. Use one of this:

  1. DAX Measure MyNow = TODAY() returns single date

  2. PowerQuery MyNow = DateTime.LocalNow() returns table with single row & col

Related questions

Show/Hide column in Power BI Table/Matrix visual

Is there any possibility to show or hide the column in Table/Matrix visual in Power BI report by user dynamically? For Example, I have a table view with columns COLUMN-1, COLUMN-2, COLUMN-3. Now I may have filter drop down …

Read More
Creating a Measure that returns DISTINCT COUNT by Country and Brand in Power BI

I have a table like below: Country, Advertiser, Brand, Spend C1, A1, B1, 10 C1, A1, B2, 5 C1, A2, B3, 0 C1, A2, B4, 20 C2, A1, B1, 8 C2, A1, B5, 7 C2, A2, B6, 4 C2, A2, B3, 3 C2, A2, B7, 2 C2, A3, B8, 9 …

Read More
Subtract two Date/Time columns in Power BI

How do I subtract two Date/Time columns in Power BI. If I have: How do I find out the time difference between Last Updated and Created Time (in hours)?

Read More