Card Visual and Date Context

[AnthonyDNY]

Hello, 

I have a measure to calculate logins on last business day. This works well provided it is in a table visual. Once I add this to a card visual, it stops working UNLESS I add a visual filter of  'Relative Date' is in this day. 

Here is the measure:

Last Business Day Counts  =

            CALCULATE(
                     [Distinct Login Counts],   -

                     _Calendar[Date] = MAX(_Calendar[PriorWorkDay]

            )

I would like to make it so it works in card visual without using the viusal filters. I believe the question is - How do update the meausure so it knows to always use today? Here is a screen shot of the table, you can see the measure works in this visual.

Any help would be appreciated. 

[Anonymous · Accepted solution]

Hi @AnthonyDNY ,

You can create a calendar table without weekends. And then add an index column to capture the previous working day. For example,

Table = var _tab=FILTER(CALENDAR(DATE(2022,12,1),DATE(2022,12,31)),WEEKDAY([Date],2)<>6&&WEEKDAY([Date],2)<>7)
return ADDCOLUMNS(_tab,"Index",RANKX(_tab,[Date],,ASC,Dense))

Today's Index = CALCULATE(SUM('Table'[Index]),FILTER(ALLSELECTED('Table'),[Date]=TODAY()))

Previous Working Day = CALCULATE(SUM('Table'[Index]),FILTER(ALLSELECTED('Table'),[Index]=[Today's Index]-1))

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[djurecicK2]

Hi @AnthonyDNY ,

 You can try something like this:

Today Counts  =

            CALCULATE(
                     [Distinct Login Counts],   -

                     _Calendar[Date] = TODAY()

            )

Please accept as solution if this answers the question- thanks!

[AnthonyDNY]

Hi, 

I realize now I did not phrase the questioin clearly. I need the card visual to show last business day counts, not today's counts. So today being Monday, December 5th 2022, I want the card visual to show me counts for Friday, December 2nd, 2022.

Thanks