Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi Team,
I am using the below measure and it works fine, but I need to replace the date with the measures (Start Date & End Date) which I have created.
Start Date = DATEVALUE("01-01-"&SELECTEDVALUE('Calendar'[Year]))
Solved! Go to Solution.
Hi Amit,
I am calculating YTD but 2 of our business unit has no entries in last 2 months and thus YTD shows blank.
So I have used the above formula to replace the blanks. Now In my formula, I would like to replace the dates (in red font) with the slicer selections (Start and end dates dax measures is build based on that). When I tried to incorporate these 2 measures in YTD measure, it doesn't work.
Do you have a solution for this? Any new measure is acceptable.
Hi Amit,
I am calculating YTD but 2 of our business unit has no entries in last 2 months and thus YTD shows blank.
So I have used the above formula to replace the blanks. Now In my formula, I would like to replace the dates (in red font) with the slicer selections (Start and end dates dax measures is build based on that). When I tried to incorporate these 2 measures in YTD measure, it doesn't work.
Do you have a solution for this? Any new measure is acceptable.
@shareezsaleem ,Not very clear what you need here
For YTD you can try like
YTD =
var _max = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())
var _min = eomonth(_max,-1*MONTH(_max))+1
return
CALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max))
User | Count |
---|---|
134 | |
72 | |
71 | |
55 | |
54 |
User | Count |
---|---|
201 | |
95 | |
63 | |
62 | |
51 |