Add selected number of days to a date - using HASONEVALUE

[Uhan1101]

Hi!

I've trying to make a slicer with a numbers of days (1 - 10) which I want to add to a date column, so the user can see the sum for the day + 1-10 days. 

The number of days I've just added in a not related table, so I was thinking of using HASONEVALUE, but it's not working.

The formel I'm trying to use is;

Add_days = if(HASONEVALUE('Dage'[Antal dage]);VALUES(Dage[Antal dage])+VALUES(test_kpi1_0301[LEVERINGS_DATO]))

I'm using direct query to my data

Can anybody help me

[amitchandak · Accepted solution]

@Uhan1101 , If you try add that to new column that is not possible. In case of measure you can try

if(Isfiltered('Dage'[Antal dage]) && HASONEVALUE('Dage'[Antal dage]), Max(Table[Date])+ Selectedvalues('Dage'[Antal dage]) , Max(Table[Date]))

You can use one of the two as per need isfiltered or hasonevalue

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

[v-yangliu-msft · Accepted solution]

Hi  @Uhan1101 ,

I created some data:

Here are the steps you can follow：

1. Select Modeling – New Parameter.

2. Create measure.

Measure =
MAX('Table'[Date]) + [Slicer_Day Value]

3. Result:

Best Regards,

Liu Yang

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

[amitchandak · Accepted solution]

@Uhan1101 , If you try add that to new column that is not possible. In case of measure you can try

if(Isfiltered('Dage'[Antal dage]) && HASONEVALUE('Dage'[Antal dage]), Max(Table[Date])+ Selectedvalues('Dage'[Antal dage]) , Max(Table[Date]))

You can use one of the two as per need isfiltered or hasonevalue

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/