Forum Discussion

deanbland's avatar
deanbland
Helper III
5 years ago
Solved

Active Week Index Column

Hi,    I am trying to create a column on my date table that shows whether a week is the current week or not like below:    Previous Week -1 Current Week 0 Next Week 1   I am want...
Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey deanbland ,

     

    try this as a calculated column. You will always get the difference to the current week:

    Diff to current week =
VAR vTodaysWeek = WEEKNUM( TODAY(), 21 )
VAR vRowWeek = WEEKNUM( 'Calendar'[Date], 21 )
VAR vResult = vRowWeek - vTodaysWeek
RETURN
    vResult

     

    Probably replace the correct format of the WEEKNUM function, depending on where you live.

    You can find more details here:
    Calculate ISO 8601 week in DAX with hidden parameter - What the fact.bi

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

    Best regards
    Denis

    Blog: WhatTheFact.bi

selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hey deanbland ,

 

try this as a calculated column. You will always get the difference to the current week:

Diff to current week =
VAR vTodaysWeek = WEEKNUM( TODAY(), 21 )
VAR vRowWeek = WEEKNUM( 'Calendar'[Date], 21 )
VAR vResult = vRowWeek - vTodaysWeek
RETURN
    vResult

 

Probably replace the correct format of the WEEKNUM function, depending on where you live.

You can find more details here:
Calculate ISO 8601 week in DAX with hidden parameter - What the fact.bi

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi