Forum Discussion
Kjellke
Helper I
Helper IFilter/Slicer question - Several collumns
Hi everyone, I have been trying to search the forums for a solution to i problem that i have for a while now, but cannot seem to figure it out. I have been able to import all my company CRM data ...
Ashish_Mathur
Super User
Super UserHi,
Select the first, second and last column in the Query Editor and click on "Unpivot other columns". If the Value1 column has actual date entries, then create a Calendar Table and build a relationship from the Value1 column to the Date column of the Calendar Table. In the Calendar Table, write this calculated column formula = FORMAT(Calendar[Date],"MMMM"). In the visual, drag the Month column from the Calendar Table. Now we can write measures.
Kjellke