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.
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?
Solved! Go to Solution.
@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
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)
@devika It looks like you're using a column visual - change it to Card and this should help:
The 'TodayDate' is just the title of the visual.
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
@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
Proud to be a 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
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 |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |