Parameter to Change a Date

[MartySapp]

Have serached and can't seem to find a solution to this-

I have a date of an invoice and want to add some what if analysis to changes to average payment terms.

i thought i coudl use a parameter to do this, by creating a average payment term Parameter adjustment that starts at 15 and goes to 120

This was my thinking to get an Expected payment Date 

Payment Term Extender Value =

VAR  DaystoAdd = SELECTEDVALUE('Average Payment Term Extender'[Payment Term Extender])

VAR TotalFCAPP = [Total Forecast + Actual Base]

RETURN

CALCULATE('YTD Information'[Date],DATEADD('YTD Information'[Date],DaystoAdd,day))

but get this error

A single value for column 'Date' in table 'YTD Information' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result..

Alternativly i gues i could power query multiple new columns i.e +15 days +30days etc filter them on the visual.

[v-shex-msft · Accepted solution]

HI @MartySapp,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

BTW, you can also try to use the following measure formula if helps:

Payment Term Extender Value =
VAR currDate =
    MAX ( 'YTD Information'[Date] )
VAR DaystoAdd =
    MAX ( 'Average Payment Term Extender'[Payment Term Extender] )
RETURN
    CALCULATE (
        [Total Forecast + Actual Base],
        FILTER (
            ALLSELECTED ( 'YTD Information' ),
            [Date] >= currDate
                && [Date] <= currDate + DaystoAdd
        )
    )

Regards,

Xiaoxin Sheng

[some_bih]

Hi @MartySapp your issue is probably in this part

CALCULATE('YTD Information'[Date],DATEADD('YTD Information'[Date]

part 'YTD Information'[Date] should be something SUM (some table[some column]) and similar