custom measure

[nisheshved]

Hi

I am looking to build some Custome Measure in BI to use it in my visuals.

The measure i want to build is to calculate the Movement between Actuals and Budget for Month on Month data which i have plottted.  When i start creating i could not find a "Difference" or "Variance" measure formula

1. How do i do the above

2. Is there a list of all the Measure formula that are avaialble in BI

Thanks

Nishesh

[v-chuncz-msft · Accepted solution]

@nisheshved,

You may take a look at the posts below.

• http://community.powerbi.com/t5/Desktop/Students-variations-year-over-year/m-p/345749#M155124
• http://community.powerbi.com/t5/Desktop/previous-year-end-of-the-month/m-p/255600#M113850
• http://community.powerbi.com/t5/Desktop/Calculating-difference-between-ROWS/m-p/192754#M84843

[nisheshved]

thanks . i will try this out

Cheers