Measure to display the same period last year

[Anonymous]

Hi,

I need to calculate the total number of jobs from last year against this year, but only up to today. This runs from a Financial year Nov - Oct, so i need to display the figures for FY 2019 Nov - (TODAY) instead of the full year.

I have managed the follwing - however, whilst it shows the correct values (highlighted), it shows other values too which arent needed. As I won't actually be using this in a table i need to make sure it only shows the values for the same period. Any ideas what i cam doing wrong?

SamePeriodLastYear = CALCULATE(DISTINCTCOUNT(FactShipment[ShipmentID]),SAMEPERIODLASTYEAR(DateDim[MasterDate]))

Not sure if it helps but this is my Date Table, the Masterdate is filtered by the Fiscal Year.

[ibarrau]

Hi, you can try creating a condition that set as BLANK() the result if the date is after today. Like this:

Medida = 
IF (
    MAX(Table[DateColumn]) < NOW(),
    CALCULATE (
        DISTINCTCOUNT(FactShipment[ShipmentID]),
        SAMEPERIODLASTYEAR(DateDim[MasterDate])
    ),
    Blank()
)

That will work for the table for sure. If the requirement is another visualization, let us know what you need to build.

Regards,