Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Create or edit an existing semantic model.

  2. Choose to create a new measure.

  3. In Measure Properties, select Expression.

  4. On the Expression dialog box, specify the solve order if needed, and select a behavior for non-empty cells. Click theiicons to learn more.

  5. Start typing an expression in the editor section of the dialog box.

    Image RemovedGenie_4.pngImage Added
  6. As you enter text, suggested functions, semantic models, dimensions, members, and so on, are displayed.
    or-
    You can also use the 'Ask Kyvos GinieGenie' link to use automated expressions.

  7. As you enter text, suggested functions, semantic models, dimensions, members, and so on, are displayed. Click a name, then press Enter to use that item.

    Image RemovedGenie_5.pngImage Added
  8. Click the Ask Kyvos Ginie link. The Calculations using Kyvos Ginie dialog is displayed.

    Image Removedimage-20240111-072715.pngImage Added
Tip

Tip

  • You can access and read important information using the Help icon before using Ask Kyvos GinieGenie.

    Image RemovedGenie_9.pngImage Added
  1. You can also see a description of the selected function.
    To view a list of functions along with the detailed description, navigate to the Functions tab and select a function from the list.

    Image Removed

...

  1. Genie_7.pngImage Added
Tip

Tips

  • Double-click on the dialog header to access the full-screen mode.

  • Use the Undo and Redo icons as needed as you create your calculated expression. 

...