The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
On screen I have date slicer
I have measures like max date, previous month end, previous quarter end, previous year end
MaxSelectDate = MAX(Dates[Date])
PrevME = DATE(YEAR([MaxSelectDate]), MONTH([MaxSelectDate]),1)-1
PrevQE = EOMONTH(Date(Year([MaxSelectDate]),INT(DIVIDE(MONTH([MaxSelectDate])-1,3))*3,1),0)
I wish to display table like
However, I want to show only dates corresponding to MaxSelectDate, PreviousME and PreviousQE.
How can I add this in a filter?
Another related question, Is there a way I 'display' calculated table which is essentially a filtering above table based on selected measures
Thank you fr your reply. I will not contort myself
Is there a way to show data for a few selected dates like PreviousME (last month end), PreviousQE (last quarter end), PreviousYE (last year end)
you can use your measures for that. Consider feeding the slicer from a disconnected table. Not absolutely required but would make it a bit easier to troubleshoot.
Another related question, Is there a way I 'display' calculated table which is essentially a filtering above table based on selected measures
You can use table variables inside a measure but the eventual result must be a scalar value. If you really want to contort yourself you can stuff the table data into a concatenated string and display that.