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,
I have given user selection for YTD,QTD and MTD.So when user selects any of these i need to display the related from Month year to To month Year.
Example : If user selects YTD and i have data from Jan'19 to Sep'19.So in a text object i need to display as (Jan'19 to Sep'19) If selected year is 2018 Then i need to display (Jan'18 to Dec'18). Same with QTD and MTD selections. Could anyone pls help me on this.
Thanks & Regards, Abhilash
Solved! Go to Solution.
So I believe that you want to say that the value/measure that you are calculating, for the last 3 months is 0.
So you can create measure as below:
Dynamic Range =
VAR SelectedYear = YEAR(SELECTEDVALUE(Date[Year]))
VAR CurrentYearMonth = CALCULATE(FORMAT(LASTDATE(Date[Date]),"MMM"),FILTER(Table,[Measure]=0))
RETURN
IF(YEAR(TODAY())=SelectedYear,"Jan "&SelectedYear&" - "&CurrentYearMonth&" "&SelectedYear,"Jan "&SelectedYear&" - "&"Dec "&SelectedYear)
Please let me know if it didn't.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |