Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Help appreciated
Help me
Help me please
Help Requested
  • amitchandak's avatar
    amitchandak
    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])

VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
4 years ago

Hi Anonymous 

 

Can you post sample data as text and expected output?
Not enough information to go on;

please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
4. Relation between your tables

Appreciate your Kudos!!
LinkedIn:www.linkedin.com/in/vahid-dm/