Multiple Date Calculations in Slicer from Row data
I have a dataset that has multiple different date calculations on the same row. Date1,2,3,etc. There are 12 separate date differential calculations between about 6-8 different date columns on the same row. Is there a way to calculate all of those separate calculations then wrap into a slicer? I tried unpivoting but this will only display the actual date and not the calculation. I have it running properly another way but everything is on separate tabs. I included an example of what I am trying to do as I am probably not detailing it very well.How to exclude certain value within Filter (illustrated on the bottom DAX)?
I have a Measure that has DAX code something like this: Occupancy % Total Rest = Divide( calculate( sum(tblTrend[Ave Census]), FILTER ( tblTrend, tblTrend[FacilityCode] in VALUES('tblKey'[FacilityCode]) ) ), calculate( sum(tblOccupancy[Capacity]), FILTER ( tblTrend, tblTrend[FacilityCode] in VALUES('tblKey'[FacilityCode])) ) ) I would like to add more excluded value of something like tblKey'[FacilityCode] = " 61" to it or tblKey'[FacilityCode] = " 61" or "52" along with VALUES('tblKey'[FacilityCode]) on certain Measures. The reason that I am trying to do is, currently, this measure dynamically changes value by how user selects slicer called "Facility Name". But, I would like to modify the calculation of this measure by adding another condition to exclude value(s). In SQL, it would be like: Where tblKey'[FacilityCode] not in ('61') or even like Where tblKey'[FacilityCode] not in ('61', '52') on other future scenario where multiple values need to be excluded. When I use slicer "Facility Name", and I want to show all Facilities (Valley, Ally, Jack) on rest of visuals, but I would like to apply this exclusion on only certain Measures. How do I express that? I have attached PBI file here for reference: This particular CARD (that shows 91.9%) is the code (measure called "Occupancy % Total Rest") shown on the top. So, in this case, instead of 91.9%, I would like to see 80.9% because FacilityCode of 61 (Jack) is excluded. Thank you.
Last N quarters from selected quarter and year
Hi Team, I have requirement that when i'm selected quarter, bar graph need to show last 5 quarters from selected quarter. I have sales table and i need to check how many sales are happend in last 5 quarters. For example, I have year Slicer and Quarter Slicer, i selected 2023 qtr 1 then i need to show qtr1-23, qtr4-22, qtr3-22, qtr2-22, qtr1-22 Regards, Siva
Subtraction of Oil between two difference dates
Hi all, I need the dax for this issue, please help. I need to have the subtraction of oil between two dates. For example, Oil on January 1 12 Oil on January 2 5 Oil on January 3 0 Oil on January 4 11 What is the diffrence between last day (January 4) and first day (January 1) = (12+5+0+11) - 12 = 16
