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 there, I'm facing with the following problem.
I need to create an Last Year measure.
then I created a calculated group like this:
v_dim_time and v_fact_sales are related to 1:n
var DayToCompare = today()
var DateLastYear = EDATE(DayToCompare;-12)
return
calculate(
SELECTEDMEASURE ();
year(v_DIM_TIME[CALENDAR_DATE_SQL]) = Year(DateLastYear);
v_DIM_TIME[CALENDAR_DATE_SQL] <= dateLastYear
)
My problem is how can I to made the formula dynamical, saying for example that ytd will be evaluated at today - 365 if no other selection are made by time slicer otherview keeping the value selected ?
Thank you in advance
Solved! Go to Solution.
@Anonymous
Using ISFILTERED() function you can identify if the column is filtered or not. Based on that, you can switch your logic.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
Hi @Anonymous ,
Can you please share the sample data and expected output.
Have calculated values where the column changes dynamically i.e shows Total Cost incase Filter in not selected and shows Total Sales if the filter is selected.
The Date Slicer is from the Calendar Table.
@Anonymous
Using ISFILTERED() function you can identify if the column is filtered or not. Based on that, you can switch your logic.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
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 |
---|---|
44 | |
21 | |
20 | |
15 | |
13 |
User | Count |
---|---|
45 | |
41 | |
39 | |
19 | |
19 |