how to show in power bi desktop last refresh date as weekdays

[sreddy47652]

Hi Team, I need some help on dax to display last refresh date as Previous day, for example if you open the report on Monday then it should displat last refresh date as Friday(Excluding Weekends) and same way i want to display data as last friday. So can anyone help me how to accheive on this.

1. I need to display tile as last refresh date as previous day.

2.I need display data on kpi or card for previous day based on refresh.

I have writen the below formula but both are returning as Last refresh date but it's not excluding weekend. when i open the report in Monday i should see Fridays refresh date .

Revenue Refresh =

var a = CALCULATE(MAX('WWR Details'[Fiscal Date]), 'WWR Details'[Actual Indicator] = "Actual", REMOVEFILTERS('Business HM Hrchy'), REMOVEFILTERS('Rpt Loc HM Hrchy'))

var b = CALCULATE(MAX('WWR Details'[Fiscal Date]), 'WWR Details'[Actual Indicator] = "Actual", REMOVEFILTERS('Quarter Selector'[Fiscal Quarter Alias]), REMOVEFILTERS('Business HM Hrchy'), REMOVEFILTERS('Rpt Loc HM Hrchy'))

var c = CALCULATE(MAX('Fiscal Calendar'[Date]), 'Fiscal Calendar'[Date] = a, REMOVEFILTERS('Quarter Selector'[Fiscal Quarter Alias]), REMOVEFILTERS('Business HM Hrchy'), REMOVEFILTERS('Rpt Loc HM Hrchy'))

var d = CALCULATE(MAX('Fiscal Calendar'[Date]), 'Fiscal Calendar'[Date] = b, REMOVEFILTERS( 'Quarter Selector'[Fiscal Quarter Alias]), REMOVEFILTERS('Business HM Hrchy'), REMOVEFILTERS('Rpt Loc HM Hrchy'))

//return upper(FORMAT(a, "dd-MMM-YYYY"))

var e = IF(ISBLANK(a), upper(FORMAT(d, "dd-MMM-YYYY")), upper(FORMAT(c, "dd-MMM-YYYY")))

return "As of : " & a

[VijayP]

@sreddy47652 

https://community.fabric.microsoft.com/t5/Service/Last-Date-Refresh-Card/m-p/2966697

try using this and let me know if still you are not aheiving what you require!