Forum Discussion
admin11
Memorable Member
Memorable MemberHow to make YTD_DATE expression display dynamic ?
Hi All v-yalanwu-msft amitchandak have help me on below post :- https://community.powerbi.com/t5/Desktop/How-to-add-period-YTD-table/m-p/1828677#M709125 Now when user click on 2016 , it still dis...
admin11
You are filtering the Year in the date. try change it to [Date].[Year]Measure = IF(ISFILTERED('Table'[Date].[Year]),FORMAT(MAX('Table'[Date]),"MMMM-YYYY"),FORMAT(TODAY(),"MMMM-YYYY"))
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
admin11
You are filtering the Year in the date. try change it to [Date].[Year]
Measure = IF(ISFILTERED('Table'[Date].[Year]),FORMAT(MAX('Table'[Date]),"MMMM-YYYY"),FORMAT(TODAY(),"MMMM-YYYY"))
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
admin11Memorable Member
Memorable MemberAnonymous
Kindly share the PBI file , so that i can understand , how to change the Year field for select to Date.Year
Paul