How to select a day of the week and show it in a card

[Rigolleto]

Hi,

I need to show in a card data related with daily sales, as the screenshot shown, notice that I have Department , day of the week and sales, do i need to do is in a slice choose for a department then behide scene get the last day of the week populated with sales, in this example sales for Tuesday , in the first example DEP1 was selected and the last day sales uploaded was Tuesday, if I pick from the slice DEPT2 then the logic shoudl check for the las day loaded, in this case Yuesday and populate the card with 80.

Thanks  in advance!!!

[v-yuta-msft · Accepted solution]

@Rigolleto ,

You may create a measure using DAX below:

Result = 
VAR Last_Index = CALCULATE(MAX(Table1[Index]), FILTER(Table1, Table1[Sales] <> BLANK()))
VAR Last_Day = CALCULATE(MAX(Table1[DayOfWeek]), FILTER(Table1, Table1[Index] = Last_Index))
VAR Sales = CALCULATE(MAX(Table1[Sales]), FILTER(Table1, Table1[DayOfWeek] = Last_Day))
RETURN 
CONCATENATE(Last_Day, CONCATENATE(UNICHAR(10), sales))

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.