QQube provides hundreds of natively constructed calculated columns - as well as several hundred additional PowerBI calculated columns. But there will be times you will need your own columns to represent the data the way you want to see it.
PowerBI provides two types of additional columns:
Let's say that the first two characters of an item in QuickBooks represent the manufacturer. You could add a column for this, and create a formula that parses the left two characters of an item name string.
The formula in this case is left('Item'[Item Name],2)
You can open up any detail Power BI example from the QQube Configuration Tool, and see dozens of examples (over 200 Measures in all).
The examples contain aggregations of varying types.
PowerBI provides two avenues for creating Measures:
Microsoft provides several tutorials:
is requesting access to a wiki that you have locked: https://clearify.com/wiki/view/1415/creating-your-own-fields-and-columns