Using a Single Date as a Parameter for Aging AP/AR

[pcowman1]

I'm trying to use a Parameter to change the date that I age AR and AP by. Usually I would just use Today() but instead I want to use the parameter AgeByDate. However, when I update the parameter in Desktop or in the service it doesn't change any of the numbers.

In M Query I created a column with the following:

#"Add Age" = Table.AddColumn(#"Filtered Rows", "Doc Age", each Duration.Days(@AgeByDate - [Document_Date]))

[mwegener]

Hi @pcowman1,

did you solve your problem?

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[pcowman1]

@mwegenerI haven't had a chance to try yet. Maybe this week. 

[Anonymous]

Create one dummy Date table and create one after date slicer which allow user selection input.

Then Create below Column for age calculation.

int(YEARFRAC(Table[Date_Of_Birth],MIN('Date'[CALENDAR_DATE])))

[v-juanli-msft]

Hi @pcowman1 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case?

If not, please let me know.

Best Regards

Maggie

[v-juanli-msft · Accepted solution]

Hi @pcowman1 

Create what-if parameter in Power BI,

Then create a measure

age = DATEDIFF(MAX([birthdate]),DATE([year Value],[month Value],[day Value]),YEAR)

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mwegener]

Hi @pcowman1 ,

did you do a data refresh?

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[pcowman1]

I don't want to do a data refresh every time the date changes.

[mwegener]

Hi @pcowman1 ,

Unfortunately, this is part of a change in Power Query.

At runtime, it only works with DAX and a what-if parameter.

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.