On the fly calculations on Power BI

[Saloni]

Hi everyone!

I have been using Power BI for a week now. I need to do some on the fly calculations that will help me visualize data. Is it possible to do this with tables already loaded from excel?

For eg.

I have data on revenues and EBIT. I want to see the changes in EBIT/Rev given, say 10% increase in revenue.

Can I do this without adding a separate column in the table?

Would appreciate some guidance.

Thanks in advance!

[himanshu56 · Accepted solution]

Hi @Saloni

That is very much possible. You dont have to add any table in your original Excel file.

You can either create a measure or a new column after loading the data set from Excel.

To learn more about how to create columns or measures, please have a look at the following link:

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-quickstart-learn-dax-basics

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-tutorial-create-calculated-columns

Hope this helps!!

Thanks,

Himanshu

[Saloni]

Will I be able to add a slicer for revenue? To see changes in EBIT/Rev as soon as I select a particular level of revenue.

[himanshu56]

Yes, you can use slicer also. Use Chiclet Slicer availalbe here.

To learn more about Chiclet slicer, see this video :

https://www.youtube.com/watch?v=iYOkJ1APueY

PowerBI Desktop helps you visualize and analyze data according to your needs. 

Thanks,

Himanshu