Level Of Detail Expression

[Anonymous]

Does anyone know how to implement the formula of LOD in Tableau into Power BI (DAX)?

Formula:

if [Last Update Date] = { FIXED : MAX([Last Update Date])} then "Current Week"
elseif [Last Update Date] = { FIXED : MAX(if [Last Update Date] <{ FIXED : MAX([Last Update Date])} then [Last Update Date] end)} then "Previous Week"
END

Thanks,

[v-luwang-msft · Accepted solution]

Hi @Anonymous ,

Try following:

base data:

Measure:

week = 
IF (
    WEEKNUM ( ( MAX ( 'Table'[Date] ) ) ) = WEEKNUM ( TODAY () ),
    "Current Week",
    IF (
        WEEKNUM ( ( MAX ( 'Table'[Date] ) ) )
            = WEEKNUM ( TODAY () ) - 1,
        "Previous Week",
        "null"
    )
)

Final get:

And if you not want to get a measure,but rather to new column,use the following dax:

week2 = 
IF (
    WEEKNUM ( (  'Table'[Date]  ) ) = WEEKNUM ( TODAY () ),
    "Current Week",
    IF (
        WEEKNUM ( ( 'Table'[Date]  ) )
            = WEEKNUM ( TODAY () ) - 1,
        "Previous Week",
        "null"
    )
)

tip:

WEEKNUM([date],1) - the first week of the year, 1 means counting from Sunday, 2 means counting from Monday,adjust as you need!

Wish it is helpful for you!

Best Regards

Lucien

[amitchandak]

@Anonymous , if you want get column with this week and last week refer

Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1
Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],2)
Week Type = Switch( True(),
WEEKNUM('Datedim'[entrydate] ) = WEEKNUM( TODAY() ),"This Week" ,
WEEKNUM('Datedim'[entrydate] ) = WEEKNUM( TODAY() )-1,"Last Week" ,
[Week Name]
)

How work with Fixed LOD in power bi   - https://www.youtube.com/watch?v=QdnOHcZqkPU

for WOW comparision

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8

[Anonymous]

This is what i was hoping to get

 @amitchandak