Changing Date Format to use in Pivot
SummaryChanging Date Format to be able to use Date as a Measure in a Pivot Table
I have searched high and low. I am trying to pull a usage report and wanted to use the Month and Year to track usage per user. The hiccup I encounter is with the date format. I have changed the format, but when I use it as a measure it errors out, so I can't see per month how many times a user accessed. I am sure I am missing something, or formatting the date wrong, I am using CAST("User Last Login Date"."User Last Login Date - Date" AS DATE). Appreciate any feedback.