Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
devika
Helper II
Helper II

Displaying Today date in Card

I'm trying to dipslay today date to display in a card.

 

I've created the measure todaydate=today().

 

The card is displaying todaydate not the actual 'Date' itself. Not sure what I'm missing?Capture.PNG

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@devika , Measure

todaydate=today()

Should work. Just check you are using card visual.

 

You may like to show max date from a table

max Date = maxx(Table, table[date])

or

max Date = maxx(all(Table), table[date])

refer to my video on this : https://www.youtube.com/watch?v=p4r4BhWuK-c&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=53

View solution in original post

4 REPLIES 4
devika
Helper II
Helper II

Thanks everyone for your time.. I was using wrong visual and moved to card and it works fine (Please bear with me this is my first Dashboard)

AllisonKennedy
Super User
Super User

@devika It looks like you're using a column visual - change it to Card and this should help: 

AllisonKennedy_0-1608536912459.png

The 'TodayDate' is just the title of the visual. 


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

negi007
Community Champion
Community Champion

@devika the measure you have created will only shows today's date. Evertime you open the powerbi file or dashboard it will refresh today's date and will show the current date.

 

if you want to show any other date, please write back




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos



Proud to be a Super User!


Follow me on linkedin

amitchandak
Super User
Super User

@devika , Measure

todaydate=today()

Should work. Just check you are using card visual.

 

You may like to show max date from a table

max Date = maxx(Table, table[date])

or

max Date = maxx(all(Table), table[date])

refer to my video on this : https://www.youtube.com/watch?v=p4r4BhWuK-c&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=53

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.