Forum Discussion
Anonymous
4 years agoNot applicable
Deviation Formula - Dax year wise
i have three 4 years data in my table . actuals values for following 4 years 2019,2020,2021,2022 2019 2020 2021 2022 Jan 100 345 56...
- 4 years ago
Anonymous , Unpivot this data have year on rows
https://radacad.com/pivot-and-unpivot-with-power-bi
then try measure like these and take diff
This Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Year'),'Year'[Year]=max('Date'[Year])))
Last Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Year'),'Date'[Year]=max('Date'[Year])-1))diff = [This Year]-[Last Year ]
diff % = divide([This Year]-[Last Year ],[Last Year ])Have year table
year = distinct(Table[year])
Anonymous
4 years agoNot applicable
amitchandak i am trying hide column header name in table . it is possible hide column header name ?
amitchandak
Super User
4 years agoAnonymous , I doubt an option hide column header, What I have done is past is font color same as the background