Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I have a dataset, simplified version below, what I have been asked to provide a tile which highlights when Data has been changed and also the TO and FROM values ?
Example on data below would show
03/09/2021 Changed from 8400 to 8500
05/09/2021 Changed from 8500 to 8400
Date | Planned | Changed |
01/09/2021 | 8400 | NO |
02/09/2021 | 8400 | NO |
03/09/2021 | 8500 | YES |
04/09/2021 | 8500 | NO |
05/09/2021 | 8400 | YES |
06/09/2021 | 8400 | NO |
07/09/2021 | 8400 | NO |
08/09/2021 | 8400 | NO |
Is this possible and any ideas or suggustions would be appreciated?
Solved! Go to Solution.
Hi @Anonymous ,
Create two measures.
previous = CALCULATE(SUM('Table'[Planned]),FILTER(ALL('Table'),'Table'[Date] = EDATE(SELECTEDVALUE('Table'[Date]),-1)))
tile = IF(SELECTEDVALUE('Table'[Changed])="YES",MAX('Table'[Date])&" Change From " & [previous] & " To " & SELECTEDVALUE('Table'[Planned]),BLANK())
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards
Community Support Team _ Polly
Hi @Anonymous ,
Create two measures.
previous = CALCULATE(SUM('Table'[Planned]),FILTER(ALL('Table'),'Table'[Date] = EDATE(SELECTEDVALUE('Table'[Date]),-1)))
tile = IF(SELECTEDVALUE('Table'[Changed])="YES",MAX('Table'[Date])&" Change From " & [previous] & " To " & SELECTEDVALUE('Table'[Planned]),BLANK())
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards
Community Support Team _ Polly
@Anonymous , Try a new column like
new column =
var _max = maxx(filter(Table, [Date] <earlier([date])),[Date])
return
if(maxx(filter(Table, [Date] <earlier([date])),[planned]) <> [Planned] , "No", "Yes")
User | Count |
---|---|
85 | |
82 | |
66 | |
53 | |
47 |
User | Count |
---|---|
102 | |
50 | |
42 | |
39 | |
38 |