Forum Discussion
Deviation Formula - Dax year wise
- 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 , I did not get this
is there any possible to hidden column header in table ?
If you trying to hide a column in visual, I doubt that
amitchandak i am trying hide column header name in table . it is possible hide column header name ?
- amitchandak4 years ago
Super User
Anonymous , I doubt an option hide column header, What I have done is past is font color same as the background