The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
I am new to Power BI I want to highlight the value in matrix visual if its less then pervious date value. for example, Van_no 0016 & 1005 have less mileage on 08-Apr-20 as compare to 07-Apr-20 and the same condition is for 06-Apr-20 vs 07-Apr-20 also.
thanks in advance.
If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly.thanks!
Dear All,
Not found any solution from the community I tried a lot but failed.
You probably want to create a flag measure like:
Flag Measure =
VAR __Measure = [Current Measure]
VAR __Date = MAX('Table'[Date])
VAR __Previous = CALCULATE([Current Measure],FILTER('Table',(__Date - 1)))
RETURN
IF(__Measure < __Previous,1,0)
can you please correct below because I am unable to put the column name without function.
User | Count |
---|---|
58 | |
54 | |
53 | |
49 | |
30 |
User | Count |
---|---|
177 | |
88 | |
70 | |
48 | |
48 |