Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
My card visual should show total errors from the previous day's accounts but it's returning 'blank':
I've used the following measure for the field value:
Do I need to rename fields or tables in the DAX measure?
Solved! Go to Solution.
You can use the following adjusted DAX expression:
Error Count =
VAR CurrentDate = TODAY()
VAR PrevDay = CurrentDate - 1
VAR DayOfWeek = WEEKDAY(CurrentDate, 2) -- 2 = Monday, 7 = Sunday
VAR SelectedDate =
IF(
DayOfWeek = 1, -- If today is Monday, check for Friday's data
CurrentDate - 3,
PrevDay
)
RETURN
CALCULATE(
COUNTROWS('Table'),
'Table'[Date] = SelectedDate,
'Table'[Status] = "Error"
)
The results are as follows:
Best Regards
hackcrr
If I have answered your question, please mark my reply as solution and kudos to this post, thank you!
Great! It worked! Thank you for your help!
You can use the following adjusted DAX expression:
Error Count =
VAR CurrentDate = TODAY()
VAR PrevDay = CurrentDate - 1
VAR DayOfWeek = WEEKDAY(CurrentDate, 2) -- 2 = Monday, 7 = Sunday
VAR SelectedDate =
IF(
DayOfWeek = 1, -- If today is Monday, check for Friday's data
CurrentDate - 3,
PrevDay
)
RETURN
CALCULATE(
COUNTROWS('Table'),
'Table'[Date] = SelectedDate,
'Table'[Status] = "Error"
)
The results are as follows:
Best Regards
hackcrr
If I have answered your question, please mark my reply as solution and kudos to this post, thank you!