How to plus date using quick measure fields.

Question

Hi All,I need to do a kind of dateadd, adding the amount of months to specific date, but these two field are quick measure and I don`t know how to do it.If someone please can help me on this:Example:Field 01:&nbsp;Last_Sales = LASTDATE(Billing[Date])Field 02:&nbsp; Last_Qty = CALCULATE([DONE_QTY],FILTER(Invoicing,Billing[Date] = MAX(Billing[Date])))Field 03 and 04 Next Buy and&nbsp;Next Buy Month/YEAR (I nedd help here I don`t know how to calculate)Result:01 Last_Sales&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 02 Last_Qty&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 03 Next_Buy&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 04Next Buy Month/YEAR01/01/2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Result expected: 01/11/2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11/2022&nbsp;Thanks.

daxtreme · Answer

Hi&nbsp;crhisbergas&nbsp;&nbsp;Please note that Best Practice says one should never use Quick Measures. One should always create explicit measures, thus making one's life easier.

ailsataoye · Answer

Hi&nbsp;crhisbergas&nbsp;I tried to restore your scene, but failed. Could you please provide your PBIX file(remove sensitive info) ?&nbsp;

Forum Discussion

How to plus date using quick measure fields.

2 Replies

Related content

Cant use data fields in measure.

Create a dynamic measures using field parameter measure values

If field is NULL then use other field

Field Parameter Contains Field Also Used in Measure

using field parameter inside a measure