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 August 31st. Request your voucher.
Hello,
I want to show a time series in a graph and only the value of the last selected month in a table. The values of the time serie cannot be sum. I trying to use the folliwing measure:
Hi, @Jul1an0
Please try the following formula.
pimLastValue =
CALCULATE (
_pim[pim_total],
FILTER (
ALLSELECTED ( dCalendar[date] ),
dCalendar[date] = MAX ( dCalendar[date] )
)
)
If this does not solve your problem, please provide example data.
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.
User | Count |
---|---|
12 | |
9 | |
6 | |
6 | |
6 |
User | Count |
---|---|
24 | |
14 | |
14 | |
9 | |
7 |