Column names must be dynamic i.e. we should be able to change the column names in a Table/Matrix
fbcideas_migusr
6 years agoNew Member
'@Sebastian, you can achieve your required output today by putting the year attribute on the columns then changing the measure expression to the following = calculate(sum(value); FILTER(VALUES('Date'[Year]), 'Date'[Year] = year(today () )-2)) This measure will only return a value against the current year, it will return blanks against any other year which Power BI will automatically filter out.
Recent ideas
Allow Detect Data Changes for Historic Data Outside Incremental Window
In Power BI Incremental Refresh,Detect Data Changes only works inside the incremental refresh window. If historic data gets updated, Power BI cannot detect or refresh it unless I expand the increment...NAGAKEERTHI_Y1 hour agoNew MemberNew106Views1like1CommentImproving complexity of Page Navigator in PowerBI
The page navigator could be improved in multiple ways to help reports that have many pages: Allow scroll in vertical view Allow pages within the navigator (EX: using a right and left carrot to sho...kreid3 hours agoNew MemberNew75Views2likes2Comments