Forum Discussion
Cards not posting filtered amount
I am using a three cards to show me our companies Open Orders, Scheduled to Ship Order and Invoice Orders. As many of the open orders are from several months back I created an "As of" month to tell me what the amount of open orders are as of a certain day. For example, as of 4/1 we had $63k of open order but on 4/2 we had $84k.
When I created the card I am using the in between date slicer function it adds both dates together which I dont want. I would like the card to go off the last date. In other words between 4/1-4/2 we had $84k of open order not $147k worth of open orders. Hopefully this makes sense.
Hi roguetrader87 ,
My Sample:
Measure:
Measure = CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Date] = MAX('Table'[Date])))Result is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
roguetrader87 , You need to follow apporch like HR Analytics
Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970But will this affect other tables which I have created that need a summation of prior days?
Hi roguetrader87 ,
My Sample:
Measure:
Measure = CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Date] = MAX('Table'[Date])))Result is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
