Forum Discussion
thameem10
1 year agoFrequent Visitor
Dynamic Column calculation based on Slicer Selection
I have 3 Tables "Variables", "Sales Data" and "Scrap Ratio". The Variable Table holds the year from 2009 to 2025. Scrap Ratio has the Age Number wise Category description and Scrappage rate and s...
- 1 year ago
Hi,
PBI file attached.
- 1 year ago
Hi Ashish, Thanks a lot for solving this in Power BI. I apriciate your expertise in this space.
thameem10
1 year agoFrequent Visitor
Hi Ashish, Thanks for your reply. Please have this file link for your understanding of the formulaes.
Active Units by Selected Year.xlsx
The Idea is to see the pivot data Active Units basis the selected year.
- Ashish_Mathur1 year agoSuper User
Hi,
PBI file attached.
- thameem101 year agoFrequent Visitor
Hi Ashish, Thanks a lot for solving this in Power BI. I apriciate your expertise in this space.
- Ashish_Mathur1 year agoSuper User
You are welcome.