How to create Start Time and End Time Slicers for single Datetime column
Hello Team, We have one Table. This is the below columns, Date-Time , value and Legends. How to create different Start Time (Hours, Minutes ) and End Time (Hours, Minutes) Slicers . Please find the below screenshot for reference
Sort by ASC when value is present
Hello, I'm trying to sort a column, by another column when it's present. The picture shows Categories, in bold, Names as unbolded text, and beneath the names not visible in the picture is a GL number for each name. This GL number is only present in names under the category SG&A. I'm trying to sort these values by ascending them in my matrix. Any ideas?
Count number of working days current month
Hi all, I am trying the build a sales report and for one metric I would like to show the average tonnes sold per day. In order to do this, I need to embed a dynamic calculation in my calendar table that count the amount of working days (mon-fri) past in the current month. This calculation needs to reset itself every single month. On top of that, I would like to save the total working days in the month when the month has completed. I cannot wrap my head around this and hope that one of you can help me out. Thanks
