Forum Discussion
Chanakya_vcr
Helper II
Helper IIDynamic Column Names and Measures in Power BI Matrix Based on Selected Year and Month
Question: Hi Everyone, I am trying to create a Power BI matrix visual to display sales measure for the Current Month Sales (CM), Previous Month Sales (CM-1), Last 2 Months Sales (CM-2), and Last...
Ashish_Mathur
Super User
Super UserYou are welcome. Not clear abut what you are trying to say. What i have shown you in the file is the only way i am aware of solving the problem.
Chanakya_vcrHelper II
Helper IIThank you for your response. I have gone through your file, and the solution with a new date table (calendar_dup) and an inactive relationship worked perfectly. However, when I tried implementing the same logic using my existing date table (Dim_Calendar) with an active relationship, it didn’t work as expected.
That’s the point I was trying to highlight. Let me know if further clarification is needed!