Last Total Balance of the last Business Day based on the selection of the Date

[gustavoleo]

Hi Power BI Lover's

Here I'm to share my simple DAX issue.

I would love to hear you

I need to build a report that shows the total balance, orders and back log orders

And I would love a measure that brings me the total of the balance of the last business day based on the selection of the date slicer

For my susrprise non of those measures works

LAST BALANCE SELECTED DATE ALLSELECTED(PREVIOUSDAY
= CALCULATE([TOTAL BALANCE];PREVIOUSDAY(ALLSELECTED(CALENDAR[Date].[Date])))

LAST BALANCE SELECTED DATE PREVIOUSDAY =
CALCULATE([TOTAL BALANCE];PREVIOUSDAY(CALENDAR[Date].[Date]))

LAST BALANCE SELECTED DATEADD = 
CALCULATE([TOTAL BALANCE];DATEADD(CALENDAR[Date].[Date];-1;DAY))

 

[v-sihou-msft]

@gustavoleo

When using time intelligence functions like PREVIOUSDAY(), DATEADD(), etc, you must give a date column with full calendar date values. These dates should be contigous and unique.

So in this scenario, you need to create a calendar table and build relationship to your fact table on Date column. Then put the Calendar[Date] into time intelligence functions to make your DAX work.

Rergards,