How to plus date using quick measure fields.

[crhisbergas]

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: Last_Sales = LASTDATE(Billing[Date])

Field 02:  Last_Qty = CALCULATE([DONE_QTY],FILTER(Invoicing,Billing[Date] = MAX(Billing[Date])))

Field 03 and 04 Next Buy and Next Buy Month/YEAR (I nedd help here I don`t know how to calculate)

Result:
01 Last_Sales            02 Last_Qty                                        03 Next_Buy                                          04Next Buy Month/YEAR
01/01/2022                    10                                    Result expected: 01/11/2022                                     11/2022

Thanks.

[AilsaTaoYe]

Hi @crhisbergas 

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

[daXtreme]

Hi @crhisbergas 

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