cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

On the fly calculations on Power BI

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver II
Resolver II

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

 

 

View solution in original post

3 REPLIES 3
Highlighted
Resolver II
Resolver II

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

 

 

View solution in original post

Highlighted

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.

Highlighted

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors