Looking to get a rolling 12 months on a measure column
I'm having the hardest time figure out the right DAX syntax to get what I'm looking for. I have a table visual that is pulling data from a SharePoint list. From this data, I need to calculate the %completed, %Incomplete, %Blank. I'm pretty sure I have those measures setup correctly. What I need to do now is get a rolling 12 months based on the %Completed measure. I've done the whole google search to see what I can find and I do find some entries that should be helping but what I'm not getting is the rolling 12 months. It's just returning the same information that's in my %Completed Column. I've created a Calendar table as well as my data table and I'm still not getting what I need. Any help to get this figured out would be very much appreciated.
How to recreate this in Power BI - IF(VLOOKUP)= "var" IF(VLOOKUP)
Hello, I have this formula from Excel that I am trying to replicate in Power BI in either Power Query Editor or as a Measure. Excel formula: =IF(VLOOKUP(I92436,references!A:C,3,FALSE)="BVX",IF(J92436<references!$F$2,"BVX","WC-BVX"),VLOOKUP(I92436,references!A:C,3,FALSE)) I have 3 datasets I'm connecting to, 2 reference tables that mirror the reference tab in the above Excel and the main dataset, also mirroring the above Excel dataset. What I have so far in Power BI, I did this as a Measure, since Power Query Editor didn't give many options. Location = LOOKUPVALUE(Scraps[LOCATION_NO],'Reference Table'[Summary 2],TRUE(),'Reference Table'[Beavex transition date].[Date]) RETURN IF((Scraps[DATE_APPLIED] < 04/26/2019, "BVX","WC-BVX"),LOOKUPVALUE(Scraps[LOCATION_NO],'Reference Table'[Summary 2])) Any help would be greatly appreciated. Thank you, Dusty
How to get Total for a measure column or an alternate DAX solution? Rank of Total for selected item.
How to get this measure on the card total? I am only looking to get 27 on card visual but it comes blank. I tried aggregation on top of this "Rank Ongoing Selected" but it did not work. I am looking to show Rank of Avg Ongoing Cost where Z_highlight = 1. There are also slicer changing the filter context hence I am using ALLSELECTED for Rank. Avg Ongoing Ranking 1 = RANKX(FILTER(ALLSELECTED(ValueMoney[Fund Provider]), NOT(ISBLANK(ValueMoney[avg ongoing cost]))), [avg ongoing cost],,ASC) Rank Ongoing Selected = VALUE( IF([Z_Highlight] = 1, RANKX(FILTER(ALLSELECTED(ValueMoney[Fund Provider]), NOT(ISBLANK(ValueMoney[avg ongoing cost]))), [avg ongoing cost],,ASC), BLANK()))Rollup the date based on condition
Hello Everyone I would like to achieve the rollup for each Category - with the max date where color is not equal to red Below is the sample data - I am getting the wrong highlighted dates - (it should filter out the date where it is red) Result Expected For highlighted date- A - 11/18/2021 B - 10/11/2021 Thanks in advance. Would really appreciate the help.Average Last 6 months accumulated
Hello dear community, I come to you so that you can help me with this DAX calculation. I need a Calculated Column to show me: the average of the last 6 months accumulated for each collaborator (in case the collaborator appears> = 6 times in the year); or in the event that the employee in the current year period appears less than 6 months, showing the average based on the number of months that the employee has been in the company in the current period, for example: Year Filter: 2021 Current month: May2021 (5) Seniority of the collaborator to May2021: 3 months (that is, the collaborator appears 3 times until May, if in June it becomes active, the collaborator when we are in June then it will appear 4 times, and so on) So the average will be = (Mar + Apr + May) / 3 Also consider that I already have a calendar table in my Power BI. Here I have an example sample of what I want exactly (column "Average Last 6 months), you can download the file here: I also leave the extract here: I read them, I hope they can help me as soon as possible. and thank you very much in advance. Nestor ReyesDax: Calculate difference between 2 values in same column based on date selection
Please assist with Dax syntax for measure to subtract the Med All value for the max date minus Min date for value in same column. The user will select 2 "As of Dates" for the calculation. Column name is Med All. 16,186 - 16,128 = 58 thanks for your assistance!Defining Dates for CALCULATE using a parameter and DATESMTD
Metric Current Period = SWITCH('Period Selection'[Period Type Selected], 1, CALCULATE(Transactions[Metric], DATESMTD( { [AsAtDate] }) ) ) Error: Cannot find table ". For the purposes of monthly reporting, I'm trying to define a range of dates to calculate a metric over. The visual will then show a single total for only that period selected. AsAtDate is a measure corresponding to the last day that the report is being made for. I think it's a problem with the way the Column/Single Column Table is being defined? Can I use a Measure in this way?
