Calculate Late Arrival Time of Employee
Respected All, With referene of screenshot of my Colomns, Our Company Time is 10 AM is Checkin and 7 Pm is Check Out, While Colums [dali_time] is a actual time of Employee arrival and leave.. First of All i want to seperate the time from 1 colums to 2 colums i.e. Time in Actual and Time out Actual then after i want a new colums which show Late arrival of Employee or Leave early employee with another column late mintues or hours calculation of employee Thanks in Advance
Pass selected slicer value(Text) into a measure
Hi, *I'm using Report Server Desktop "RS". I have a slicer that shows text values instead of numbers. I would like to create a measure that takes the selected "text"value(Column A) in a slicer, filters Column B based on the selected value in Column A. Then returns a "count" or "distinct count" of the filtered rows. I tried building a measure but I'm returned with a message "Cannot convert value XXXX of type Text to type Number". This seems like a simple formula but I'm not using the right syntax for DAX. Heres a table example: Column A-Slicer filters on this column Dog Cat Mouse Horse Column B PitBull Corgi Tabby Cat Jack Russell Thank you
Incorrect Measure Total on Matrix
Hello, I have a matrix in a report that contains a number of measures, unfortunately the measure total is incorrect for each one. I have been trying to find a solution but have so far had no luck, hence I am turning to the community to help. I unfortunately cant post the file as it contains business sensitive information, but will do my best to explain without it. Below is my final matrix, which has the correct monthly values but incorrect total: This is the formula used for each measure: Reforecast_Value_Ardley = CALCULATE(SUM(Anaplan_Electricity_Revenue[Value]), Anaplan_Electricity_Revenue[PPM_Name]="Ardley ERF", Anaplan_Electricity_Revenue[Version]="Budget FY24", Anaplan_Electricity_Revenue[Value_Type]="Electricity Revenue - Grid")+ ((CALCULATE(SUM(Volume_Hierachy_Final[Total_Volume]), Volume_Hierachy_Final[PPM_Name]="Ardley ERF") - CALCULATE(SUM(Anaplan_Volume_Daily[Value]), Anaplan_Volume_Daily[PPM_Name]="Ardley ERF", Anaplan_Volume_Daily[Version]="Budget FY24"))* AVERAGE(Reforecast_Power_Price[Reforecast_Price])) The formula filters tables and sums the data, then multiplies the data by a monthly price. I have been scouring the forums and it seems like the HASONEFILTER could be used to help with this issue, but I cant seem to get it to work. Let me know if any more information is required. Any help would be greatly appreciated. Thanks in advance, Josh
How to define Date Range for Parameters in Report Builder
Hi, I have a request to have a date range filter based on submission date in a paginated report, I am able to create the date range and it's working, however the report has only 3 years worth of data and the date range showed in filters displays all possible dates from 1800s, so users can select older dates although there's no data for those dates. I am trying to limit the date range filter to the relative dates in the dataset but I can't figure a way to do that. My paginated report is connected to a PBI dataset so I am using dax. This is my query ----------------------------------- DEFINE MPARAMETER s_start_dt = FORMAT(@s_start_dt, "MM/dd/yyyy") MPARAMETER s_end_dt = FORMAT(@s_end_dt, "MM/dd/yyyy") VAR __Table1 = SUMMARIZECOLUMNS( Query1[Category], Query1[Aggregate Underwriting Comp], Query1[violation_id_link], FILTER(VALUES(Query1[sbmsn_dt]),Query1[sbmsn_dt]>= @s_start_dt && Query1[sbmsn_dt]<= @s_end_dt) ) EVALUATE __Table1 ORDER BY Query1[sbmsn_dt] desc -------------------------------------------------- the parameters are defined as Date/Time with no available values nor default values Below is a screenshot of how I see the date rnage right now, any help would be appreciated! I have also tried the usual way where I add a calendar data source with relative dates (min and max based on my dataset), but this displays 2 boxes in the report for "From" and "To" Dates with dropdown to choose the date (like a dropdown text) which is not very intuitiveProblems checking grouped values
Good morning, I am creating a report that looks like the following; My problem is with the "Type" field that is grouped As you can see, the "Check" field gives me an error, in that field I would like to obtain the same values that are in the "P" column, which, as I said, is a grouped column called "Type" The idea is to count all the "BaleID" where "Type" is equal to "P", I have tried the following expressions and I get an error, I can't think of how to achieve it. =Count(Filter(Fields!Type.Value,"P",True, Fields!BaleID.Value)) =Filter(Count(Fields!BaleID.Value),Fields!Type.Value="P",True,CompareMethod.Binary)
