Forum Discussion

budimir's avatar
budimir
Regular Visitor
5 years ago
Solved

Calculated column where start date is fixed?

I have a calculated column where I get qty for a specific warehouse, but the problem is that the start date should always be fixed so the user can't change it (01/01/2009) and the end date is changin...
Need Help
Show and Tell
  • v-alq-msft's avatar
    v-alq-msft
    5 years ago

    Hi, budimir 

     

    Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

    Table:

     

    Calendar(a calculated table):

    Calendar = CALENDARAUTO()

     

    There is no relationship between two tables. You may create a measure as below.

    Visual Control = 
IF(
    SELECTEDVALUE('Table'[Date])>=DATE(2009,1,1)&&
    SELECTEDVALUE('Table'[Date])<=MIN('Calendar'[Date]),
    1,0
)

     

    Then you need to put the measure in the visual level filter and use 'Date' column from 'Calendar' to filter the result.

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

v-alq-msft's avatar
v-alq-msft
Community Support
5 years ago

Hi, budimir 

 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Table:

 

Calendar(a calculated table):

Calendar = CALENDARAUTO()

 

There is no relationship between two tables. You may create a measure as below.

Visual Control = 
IF(
    SELECTEDVALUE('Table'[Date])>=DATE(2009,1,1)&&
    SELECTEDVALUE('Table'[Date])<=MIN('Calendar'[Date]),
    1,0
)

 

Then you need to put the measure in the visual level filter and use 'Date' column from 'Calendar' to filter the result.

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.