Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
The original data is on Top and my attemped solution is below that , the data is time dependant so it may change as year goes by.
I am able to get the data for the date selected but I would like it to display/overwrite in all rows/dates for that customer
DAX
sel_we_dt is a measure - Selected Value (date)
mTest3 = CALCULATE(MAX('Store List'[scan_lfl]),FILTER(('Store List'),[date_sk]=[sel_we_dt]))
Customer | End of Week | Good/Bad Store Ind | Sales |
276 | 6-Mar-22 | N | 1000 |
276 | 13-Mar-22 | Y | 2000 |
276 | 20-Mar-22 | Y | 1500 |
276 | 27-Mar-22 | Y | 1700 |
276 | 3-Apr-22 | N | 800 |
A store has sales every week and they ae classified as good or bad store by its Sales ,if a user makes a data selection I want the Good/Bad Indicator to overwrite the other weeks to that weeks Good/Bad Ind.
So if 27-Mar-22 is selected then the table should be :
Customer | End of Week | Good/Bad Store Ind | Sales |
276 | 6-Mar-22 | Y | 1000 |
276 | 13-Mar-22 | Y | 2000 |
276 | 20-Mar-22 | Y | 1500 |
276 | 27-Mar-22 | Y | 1700 |
or 3-April-2022 is selected then table should look like this but there are multiple customers so it needs to be grouped by each customer
Customer | End of Week | Good/Bad Store Ind | Sales |
276 | 6-Mar-22 | N | 1000 |
276 | 13-Mar-22 | N | 2000 |
276 | 20-Mar-22 | N | 1500 |
276 | 27-Mar-22 | N | 1700 |
276 | 3-Apr-22 | N | 800 |
@earltom , The information you have provided is not making the problem clear to me. Can you please explain with an example.
refer if this blog can help
https://medium.com/chandakamit/power-bi-when-i-felt-lazy-and-i-needed-too-many-measures-ed8de20d9f79
Instead of max date based on selection, it can based on customer
calculate(Max(Table[Date]), filter(allselected(customer), Customer[ID] = max(Customer[ID]) ) )
Appreciate your Kudos.
The date is a selected value
User | Count |
---|---|
49 | |
40 | |
18 | |
14 | |
13 |
User | Count |
---|---|
100 | |
55 | |
28 | |
18 | |
13 |