Change measurement according to the date filter

[Anonymous]

I am having difficulty in this calculated field.

When the date filter is one month, it will return a column, but if the date filter is more than a month it returns a measurement.

Example:

If the date is July, go and return to Column 1.

If the date is from January to July, measure 2 will return to me

[simrantuli]

Hi @Anonymous,

From what I have understood, below measure should work for you.

IF(HASONEVALUE(Month), Sum(Column), [Measure2])

If this is not what you are looking for, please provide more information on your requirement as it is not very clear.

Best Regards

Simran Tuli

[amitchandak]

@Anonymous , refer if this can help

https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern

[Greg_Deckler]

@Anonymous Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.