Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Powernew
Regular Visitor

Ratio calculation in trial version

Is it possible to do ratio calculation in the trial version? I didn't find a way.

5 REPLIES 5
Powernew
Regular Visitor

Thanks. The trial version is what I am using and the "Open data model" option seems to be not available to me.屏幕截图 2023-08-20 192130.jpg

Hi @Powernew ,

 

As far as I know only datasets with direct lake connection mode are supported.

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.

v-tangjie-msft
Community Support
Community Support

Hi @Powernew ,

 

 

Select a dataset in the trial workspace, click "Open Data Model", and then create a new measure.

vtangjiemsft_0-1692170916734.png

 

You can use the DAX language to create measures that calculate ratios based on your data. You can also use the DIVIDE function to perform a division operation.

 

You can refer to the following documents that may be helpful to you:

Tutorial: Create your own measures in Power BI Desktop - Power BI | Microsoft Learn

Calculating ratios in dax - Microsoft Fabric Community

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

Thank you, Neeko! Do you happen to know if I can "open data model" in the web version (not the desktop version)? I'll surely keep your useful tips and try to use them!

Hi @Powernew ,

 

1.Find a trial workspace.

vtangjiemsft_0-1692581406501.png

2.Find a dataset and click "..."->"open data model",then you can create measures.

vtangjiemsft_1-1692581528512.png

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.

Top Solution Authors
Top Kudoed Authors