Need help
Hi, I am trying to report on comparing record counts between current and past years. I tried the samelastyearperiod function and the dateadd function, but I haven't had any luck. Can you please help me? Thank you. I created a fiscal year (starting from 1 April) calendar table (Date) that contains just dates, and I have a fact table that contains record ID and file-received dates. I created the following two measures. Count_recordID = count(recordID) Previous year count = calculate(count_recordID,samelastyearperiod(Date_table[date]). Inactivated the relationship between date table and fact table. I am not getting desired output. Someone can help. Thank you.
use multiple column in a single slicer's options
I've 15+ columns that consist of vehicle classes and I've built a single graph to show the statistics of all those 15column but now, I need to make a slicer. So that I can choose the desired column(out of 15 columns). so, how can we use multiple columns in a single slicer.
