Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |