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,
I have a slicer that shows sales upto todays date in earlier month (eg. today it shows what we have sold each month upto the 18th):
Solved! Go to Solution.
Hi @sw123 ,
If Monthday=DAY(DateTable[Date]) is a measure,it should be modified as below:
Monthday=DAY(SELECTEDVALUE(DateTable[Date]))
If it doesnt work, pls show me your .pbix file.You can upload it to onedrive then share the link with us.
Hi, the easiest way, when your first formula works as expected, would be to replace the <= with <
Yesterdays date = if(DateTable[Monthday] < DAY(TODAY()); TRUE(); FALSE())
Thanx, but it still doesn't work. Does it have something to do with the Monthday, that is a measure in my date table:
Hi @sw123 ,
If Monthday=DAY(DateTable[Date]) is a measure,it should be modified as below:
Monthday=DAY(SELECTEDVALUE(DateTable[Date]))
If it doesnt work, pls show me your .pbix file.You can upload it to onedrive then share the link with us.
User | Count |
---|---|
141 | |
70 | |
70 | |
53 | |
53 |
User | Count |
---|---|
208 | |
95 | |
64 | |
61 | |
57 |