Forum Discussion

Powernew's avatar
Powernew
Regular Visitor
3 years ago

Ratio calculation in trial version

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

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Powernew ,

     

     

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

     

    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. 

    • Powernew's avatar
      Powernew
      Regular Visitor

      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!

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi Powernew ,

         

        1.Find a trial workspace.

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

        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.

         

  • Powernew's avatar
    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.

    • Anonymous's avatar
      Anonymous
      Not applicable

      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.