topic Re: Add selected number of days to a date - using HASONEVALUE in DAX Commands and Tips

Add selected number of days to a date - using HASONEVALUE

Uhan1101 — Wed, 11 May 2022 05:49:26 GMT

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

Re: Add selected number of days to a date - using HASONEVALUE

amitchandak — Wed, 11 May 2022 06:02:30 GMT

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/

Re: Add selected number of days to a date - using HASONEVALUE

Anonymous — Tue, 17 May 2022 06:29:22 GMT

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