Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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;
I'm using direct query to my data
Can anybody help me
Solved! Go to 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/
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
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
@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/
User | Count |
---|---|
57 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |