Blank() value for dates from end of current month

[aemb]

Hi all

I am struggling with a measure... hope you can help! 

I have a database with contracts, and one with sales orders (by shipdate). 

I created a measure which flags whether sales orders are higher, lower, or OK compared to the contract that month. The measure gives Blank() values for either no contract/no sales order combination. But I would also like it to give Blank() for any date beyond the end of the current month.

This last part is where I cannot manage to get it to work. The underlined part in the measure throws an error: a single value for column timestamp_dt in table date dimension cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation.

any ideas? 

Contract Application =
IF(
      AND(ISBLANK([Quantity Shipped by Actual Ship Date]),ISBLANK([ContractQty by Del/Ship From])),
          BLANK(),
         IF( (([ContractQty by Del/Ship From] - [Quantity Shipped by Actual Ship Date])/[ContractQty by Del/Ship From])>0.05,
      IF((Year('date_dimension'[timestamp_dt])*100+Month('date_dimension'[timestamp_dt]))>(YEAR(Today())*100+ MONTH(Today())),Blank(),"Lower"),
          IF( (([ContractQty by Del/Ship From] - [Quantity Shipped by Actual Ship Date])/[ContractQty by Del/Ship From])<-0.05, "Higher","OK"))
)

'date_dimension'[timestamp_dt] --> main date column (eg 09-07-17 ) 

Expected result:

Quantity Shipped by Actual Ship Date	ContractQty by Del/Ship From	yearmonthnumber (Aggragated)	Contract Application MTD
23940,97	21043.14	201810	Higher
24804,02	23642.94	201811	OK
17454,86	20688.44	201812	Lower
24007,70	23047.65	201901	OK
20452,68	23990.67	201902	Lower
20789,25	24487.06	201903	Lower
2852,07	22460.74	201904	Lower
	18994.67	201905
	20451.6	201906
	19995.34	201907
	19335.41	201908

Any help would be greatly appreciated...!!

[aemb]

Would still love the community's input on this one! let me know in case the ask is unclear! Thanks a lot in advance:)

[parry2k]

@aemb please read this post to get your answer quickly https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490