Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
93 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |