Forum Discussion

ThomasWeppler's avatar
ThomasWeppler
Impactful 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

slorin's avatar
slorin
Super User
3 years ago

Hi,

 

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

Stéphane