Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Is it possible to create a Date flag based on Date slicer selection. Flag should only have Current Date (i.e. slicer value) and previous Date of slicer Date. My requirement is to use a measure along with this flag that will automatically change values for Current/Previous Dates based on slicer selection. TIA.
Solved! Go to Solution.
Hi @kumsha1 ,
Based on your description, you need to create another date table and use it as a slicer:
Table = DISTINCT('Calendar'[Date])
Create this tag measure:
Tag =
VAR date1 =
SELECTEDVALUE ( 'Table'[Date] )
VAR date2 =
SELECTEDVALUE ( 'Calendar'[Date] )
RETURN
IF ( date2 <= date1, 1, 0 )
Attached a sample file in the below, hopes to help you.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @kumsha1 ,
Based on your description, you need to create another date table and use it as a slicer:
Table = DISTINCT('Calendar'[Date])
Create this tag measure:
Tag =
VAR date1 =
SELECTEDVALUE ( 'Table'[Date] )
VAR date2 =
SELECTEDVALUE ( 'Calendar'[Date] )
RETURN
IF ( date2 <= date1, 1, 0 )
Attached a sample file in the below, hopes to help you.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@kumsha1 , for that you can create measure like this, assume the date is from date table
This Day = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])))
Last Day = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])-1))
Last Day = CALCULATE(sum('order'[Qty]), previousday('Date'[Date]))
Day behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Day))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
98 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |