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.
I am trying to make a dashboard from an excel document that gets pulled in from our internal sharepoint that my staff keep up to date. My dashboard should show the current total of workstations on the network. I have thrown in different numbers to make sure the dashboard is working correctly, but it is pulling the max value instead of the most recent value, excluding blanks.
Table View:
I created a card under visualizations and the formula is:
Solved! Go to Solution.
@thebigbamf , Try a measure like, assuming [Total Workstation Objects] is a column
LatestTotalWorkstations = LASTNONBLANKValue(AD[Date], Sum(AD[Total Workstation Objects]) )
Power bi tutorial: DAX functions: lastnonblankvalue , firstnonblankvalue: https://www.youtube.com/watch?v=cN8AO3_vmlY&t=26940s
Hi, @thebigbamf
You can try the following methods.
Measure =
Var _maxdate=CALCULATE(MAX(AD[Date]),FILTER(ALL(AD),[Total Workstation Objects]<>BLANK()))
Return
CALCULATE(MAX(AD[Total Workstation Objects]),FILTER(ALL(AD),[Date]=_maxdate))
Is this the result you expect? Please see the attached document.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Create a Calendar Table and write this measure
Latest Total Workstations = CALCULATE(SUM(AD[Total Workstation Objects]),LASTNONBLANK('Calendar'[Date],CALCULATE(SUM(AD[Total Workstation Objects]))))
@thebigbamf , Try a measure like, assuming [Total Workstation Objects] is a column
LatestTotalWorkstations = LASTNONBLANKValue(AD[Date], Sum(AD[Total Workstation Objects]) )
Power bi tutorial: DAX functions: lastnonblankvalue , firstnonblankvalue: https://www.youtube.com/watch?v=cN8AO3_vmlY&t=26940s
Thank you this worked perfectly!
User | Count |
---|---|
91 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
96 | |
89 | |
73 | |
61 | |
58 |