Forum Discussion

vsslasd1's avatar
vsslasd1
Icon for Helper III rankHelper III
3 years ago
Solved

How to have a variable date in a PowerBI

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 Period...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

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-trend/ba-p/882970

 

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

 

 

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-fc4095ae9afd
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE

vsslasd1's avatar
vsslasd1
Icon for Helper III rankHelper III
3 years ago

Thank you