Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have created a Sankey table using DAX which is basically just SOURCE, DESTINATION, WEIGHT (Summarised ticket data at different states).
I have a variable date set up to filter the data for tickets created after the variable date, however I want to make this date value changable outside of the DAX. I have not been able to figure out how to do this.
Here is a very dumbed down example of the DAX:
CX-JOURNEY = VAR from_date = DATEVALUE("2022-07-01")
RETURN
{
(
"PRE-SALES",
"SUPPORT",
CALCULATE(COUNTROWS(CONVERSATIONS), CONVERSATIONS[CREATED_AT] > from_date && CONVERSATIONS[GROUP]="Pre-Sales Engineers")
),
(
"SUPPORT",
"RND",
CALCULATE(COUNTROWS(CONVERSATIONS), CONVERSATIONS[CREATED_AT] > from_date && CONVERSATIONS[GROUP]="SUPPORT" )
)
}
Basically the goal is to have from_date selectable from outside the visual and have the Sankey visual update based on the selected date.
Hi @amitchandak
It seems to not be able detect the values within the table.
TEST = VAR from_date = SELECTEDVALUE(Date2[Date])
RETURN
{
(
"PRE-SALES",
"SUPPORT",
CALCULATE(COUNTROWS(CONVERSATIONS), CONVERSATIONS[CREATED_AT] > from_date && CONVERSATIONS[GROUPS]="Pre-Sales Engineers"),
from_date
),
(
"SUPPORT",
"RND",
CALCULATE(COUNTROWS(CONVERSATIONS), CONVERSATIONS[CREATED_AT] > from_date && CONVERSATIONS[GROUPS]="SUPPORT" ),
from_date
)
}
I added from_date as a 4th value to the table and it returns null values. I confirm the date slicer works with a simple measure.
Measure = SELECTEDVALUE(Date2[Date])
But it does not work within table creation dax.
Any Ideas?
@crispybc , Create an independent date table and then use
selectedvalue(Date1[Date])
or
maxx(allselected(Date1),[Date])
in place of static date
Just for reference
Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI
User | Count |
---|---|
65 | |
46 | |
20 | |
18 | |
15 |
User | Count |
---|---|
119 | |
41 | |
40 | |
28 | |
22 |