Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DAX for variance

Hi, I have a requirement to calculate financial report variance which has Actual and Forecast columns, ideally variance should be Actual-Forecast but since my user is looking for a different require...
Need Help
  • v-luwang-msft's avatar
    v-luwang-msft
    5 years ago

    Hi Anonymous ,

    You could use the following steps:

    Step1 ,import data and then transpose table, then apply and colse :

     

    Step 2,use the following measure:

    two and ten =
var test1=if(MAX('Table'[Column3])="Actual","ten and two",MAX('Table'[Column3]))    
var test2=IF(test1<>BLANK(),test1,MAX('Table'[Column2]))  
return test2

     

     

     

     

    Wish it is helpful for you !

     

    Best Regards

    Lucien

v-luwang-msft's avatar
v-luwang-msft
Community Support
5 years ago

Hi Anonymous ,

You could use the following steps:

Step1 ,import data and then transpose table, then apply and colse :

 

Step 2,use the following measure:

two and ten =
var test1=if(MAX('Table'[Column3])="Actual","ten and two",MAX('Table'[Column3]))    
var test2=IF(test1<>BLANK(),test1,MAX('Table'[Column2]))  
return test2

 

 

 

 

Wish it is helpful for you !

 

Best Regards

Lucien