Expressions based on visualisation figures

[willatkinson]

Hi all,

I had a table visualisation that was split into quaters via a date hiearchy.

I was wondering if you are able to to calculate expressions based on values that are produced by a visual, that don't appear in the tables of the model itself? 

For example could I write expressions that include the values of Qtr 2 here, even though the coloum isn't in the data model?

Cheers,

[Anonymous]

Hi @willatkinson ,

This effect can be achieved using the DATESBETWEEN function.Refer to the following:

Quarter 2 Sales = 
CALCULATE(
    [total_sales],
    DATESBETWEEN(
        'Date'[Date],
        DATE(Year(TODAY()), 4, 1),
        DATE(Year(TODAY()), 6, 30)
    )
)

Quarter 3 Sales = 
CALCULATE(
    [total_sales],
    DATESBETWEEN(
        'Date'[Date],
        DATE(Year(TODAY()), 7, 1),
        DATE(Year(TODAY()), 9, 30)
    )
)

Best Regards,
Adamk Kong

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

[willatkinson]

This is what I get, it doesn't pick up the date field I'm trying to reference, and won't pick up a column in place of [total_sales]

[Anonymous]

Hi @willatkinson ,

Can you provide some test data to facilitate me to answer your question as soon as possible?

Best Regards,
Adamk Kong