Forum Discussion

ThomasWeppler's avatar
ThomasWeppler
Icon for Impactful Individual rankImpactful Individual
3 years ago
Solved

Selecting a date every x week

Hi Power BI community   I have a table with five columns   1. Index: An index column 2. Assignment: A Number column that shows diffrent assignment. (In this example we will just look at [Assignm...
Need Help
  • slorin's avatar
    slorin
    3 years ago

    Hi,

     

    if 
      Duration.Days([Date] - [FirstDate]) = 0 
    or
      Duration.Days([Date] - [FirstDate])/7 = [Interval]
    then
     1
    else
     null

    Stéphane

ThomasWeppler's avatar
ThomasWeppler
Icon for Impactful Individual rankImpactful Individual
3 years ago

I have split the Interval column up and made gotten the first one or two digits in a column by themself, so the problem I have is to create the interval.