How to have a variable date in a PowerBI

[vsslasd1]

We have a PowerBI report. In this report are three dates: TransactionDate, AccountingDate and PeriodEnd Date. 

We have a selector that has three options: TransactionDate, AccountingDate and PeriodEnd Date

We want to select one of those options: TransactionDate, AccountingDate or PeriodEnd Date

From that selected value: We want either a Measure or a Column to display the selected date for each row AND we want the date filter to filter on that variable date, contigent upon the selection. 

How is this concept best performed in PowerBI. It seems a Calculated Column won't work, as this is only refreshed when the data set is refreshed. So that leaves a measure. Is this possible to do?

Thank you

[amitchandak · Accepted solution]

@vsslasd1 , Check if single date table with Active/inactive joins and userelationship can help

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

Also, explore

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE

[vsslasd1]

Thank you