Forum Discussion

Gabb's avatar
Gabb
Regular Visitor
3 years ago

Creating a calculate average 6 months fixed in a chart

Hey all, I have this chart: I want to add 2 different 6 months' averages for the sell-out and shipped. Both the seel out and shipped are 2 DAX. Shipped = CALCULATE(     SUM( 'S...
Need Help
v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi, Gabb 

I think you can add a new measure, using an if statement to replace the average value under the "forecasted" section with a blank value.

 

Best Regards,
Community Support Team _ Eason

Gabb's avatar
Gabb
Regular Visitor
3 years ago

Do you have any ideas on how I could write it?

I tried different IF statement but I was trying to connect it with a column I have on my dimView CALENDAR "DISTANCE FROM CURRENT MONTH".

IF "dimView Call[Distancefromcurrentmonth] <=0, 
Give me all the values
IF "dimView Clal[Distancefromcurrentmonth] > 0,
"Blank"

But I cannot link the mesure with that.