Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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]))
Solved! Go to 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.
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.
Create one dummy Date table and create one after date slicer which allow user selection input.
Then Create below Column for age calculation.
Hi @pcowman1
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.
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.
I don't want to do a data refresh every time the date changes.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |