Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have a formula that is going beyond the time I want it to. How should I limit the formula to fall in to the scope of the past to now and not in the future. The formula is as shown below.
SPLY INVoiced =
CALCULATE(
[Invoice Line TOtal],
SAMEPERIODLASTYEAR('Date'[Date])
)
The visual shows the formula in action. Since it is the sameperiodlastyear, it shows the formula going forward to 2024. I want it to show up to May 2023. How do I limit the Orange line to be span upto May 2023, the current time.
Solved! Go to Solution.
I have tried to limit it as shown below, still does not work. Any suggestions?
SPLY INVoiced =
Var Month = MONTH(TODAY())
return
CALCULATE(
[Invoice Line TOtal],SAMEPERIODLASTYEAR('Date'[Date]),FILTER('INV1 Invoice Rows', 'INV1 Invoice Rows'[DocDate] <= TODAY()
))
Hi @Datagulf ,
Please try:
SPLY INVoiced =
VAR _a =
CALCULATE ( [Invoice Line TOtal], SAMEPERIODLASTYEAR ( 'Date'[Date] ) )
RETURN
IF ( SELECTEDVALUE ( 'Date'[Date] ) <= EOMONTH ( TODAY (), 0 ), _a )
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I have tried to limit it as shown below, still does not work. Any suggestions?
SPLY INVoiced =
Var Month = MONTH(TODAY())
return
CALCULATE(
[Invoice Line TOtal],SAMEPERIODLASTYEAR('Date'[Date]),FILTER('INV1 Invoice Rows', 'INV1 Invoice Rows'[DocDate] <= TODAY()
))
Hi @Datagulf ,
Please try:
SPLY INVoiced =
VAR _a =
CALCULATE ( [Invoice Line TOtal], SAMEPERIODLASTYEAR ( 'Date'[Date] ) )
RETURN
IF ( SELECTEDVALUE ( 'Date'[Date] ) <= EOMONTH ( TODAY (), 0 ), _a )
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.