need help in dax

4 Topics

Productx with measure
Hi Dear DAX Experts, I know the almost excactly the same question has been asked before by sgupta22 but the solution was presented in the BI File and the file is no longer available. So let me ask for help for the following problem: I want to compound monthly growth rates. The growth rates are the result of a Measure: So far so good, but now I want to compound theses growth rates by creating an Index showing the cumulative growth and I do not know how to do it. If the rates were in a column I could use productx. But the rates are in a measure. In Excel what I need would be this: Is there a way to do this? Thanks in advance. Markus
McShock
2 years ago Place DAX Commands and Tips
940Views
0likes
3Comments
Need to find future date tasks count
Hi amitchandak I want to create a measure to find selected date task count, Task_Name Task_Start_date Task_start_time repeat_every repeat_by End Occrance End when Server Task A 20-Jan-24 10:00 1 days ProdAM Task B 20-Jan-24 12:00 2 days ProdAM Task C 20-Jan-24 15:00 15 minutes 5 25-Jan-24 ProdSM Date slicer - I want to select a one future data in my slicer, In that time_bin it should display how many tasks will come on that selected date Slicer - date slicer - 22-Jan-2024 Result should be on 22-Jan-2024 Task A and Task B will come and Task C will run 4 times then it will end Task_start_time Count 10:00 1 12:00 1 15:00 4 Server Count ProdAM 2 ProdSM 4 Result should be on 23-Jan-2024 (Task B won't come in this day) Task_start_time Count 10:00 1 12:00 0 15:00 4 Server Count ProdAM 1 ProdSM 4 Result shoudl be on 26-Jan-2024 After the end_date Task C won't come Task_start_time Count 10:00 1 12:00 1 Server Count ProdAM 2 I want the measure to create the count like above in tasks and servers
Solved
Navaneetharaju_
2 years ago Place DAX Commands and Tips
1.2KViews
0likes
6Comments
Earlier function not working well
Hi, I was trying to use Earlier function to get a list of current column value but seems not working well. The DAX is PreviousOccuranceOfWords1 = COUNTX(FILTER(MainQuery, [Start of Month]=MAXX(FILTER('MainQuery', 'MainQuery'[Start of Month] < EARLIER('MainQuery'[Start of Month]) ), [Start of Month])), MainQuery[Value]) There supposes to show the value of count of previous month, but it doesn't. If I change "<" to "<=", then it shows, but it's current month's count. Not sure where is the error.
yishenhui
3 years ago Place Report Server
680Views
0likes
2Comments
Slicer filter not working well on table with mixed columns
Hi, I have a date slicer filter, a table sheet with this date column, two measures related to this date field. The measures have "all" filters with the whole data table. When the date silcer selected "All", there is no issue. When I selecting a date range, I thought the filter should apply to the date column in the table sheet and only show the rows with the date in the range. however, it does not. It only remove some blank rows in the measure and one of the measure is not working if the date is not in the range. The screenshot as below". Is there a way to let the table sheet show correctly after select the date range? Or any solution similar? before select date range: The two measures are: (using Offset to show previous log time if exist and calculate the duration) EachLog_PreviousLogTimestampe = CALCULATE(max('Activity-EachLog-Detail'[LogTimeStamp]),all('Activity-EachLog-Detail'),offset(-1,all('Activity-EachLog-Detail'[Incident],'Activity-EachLog-Detail'[LogTimeStamp]),ORDERBY('Activity-EachLog-Detail'[LogTimeStamp]),KEEP,PARTITIONBY('Activity-EachLog-Detail'[Incident]))) EachLog_Gap_days = DATEDIFF([EachLog_PreviousLogTimestampe],max('Activity-EachLog-Detail'[LogTimeStamp]),HOUR)/24
yishenhui
3 years ago Place Report Server
251Views
0likes
0Comments