User Profile
Broly
Frequent Visitor
Joined 3 years ago
User Widgets
Contributions
Get value from another row in filtered table
Hi, I have a table that looks like this : I have applied a bunch of filters on it : status = "a" or "b", date1= between 1 jan 2023 to 31 jan 2023, date2 = 1 jan 2023 and know it looks like this : For each ref that I have in the filtered table, I want to know if that ref exist in "c" status in the unfiltered table. in this example it would look like this : I tried to create a measure that counts the number of ref using calculate with "removefilter()" But I keep having duplicate. How can I write a measure that keeps the filtered table as and tells if the ref exist in the whole unfiltered table ? Would really appreciate your help thanksprevious day on text
I have a table as follow : Please keep in mind that I dont have a date column in the table but I use a date table. I want to create a measure to get the previous day supply scheme. When I use the "previousday()" function to get the previous day quantity, it works fine. I actually use this formula and it works fine as well : Qty previousday = CALCULATE(SUM(Table[quantity),FILTER ( ALL ( 'Date Table' ), 'Date Table'[Date] = MAX('Date Table'[Date]) - 1 )) Problem is now I want to get the previous day supply scheme. Any easy way of doing this ? Thanks for you helpcompare values in different rows
I have a table that contains sales informations. each sales id contains a product with quantities. the data is historized thanks to a column containing the dates (note that this column in an integer and not date column). What I want is a table that will show the difference between today and yesterday. Like this : The date is from a live connection. How can I do this using DAX ? thanks
