Forum Discussion
Solved
Dynamic text based on Month Name IMPOSSIBLE?
Power BI Community, Reaching out for help! I want to create a dynamic text that changes based on the filtered selection. I have been attempting to use if and iscrossfiltered in DAX. I don't k...
Anonymous
Problem Solved...
The "-1" in the current month line had to be changed to a "0".
Many thanks,
Gdexter
Try this
Measure =
IF (
ISFILTERED ( 'DAILY DATEs'[Daily] ),
"Looking at payment data between " & [SELECTED MONTH - 1]
& [SELECTED MONTH],
"Please Select a month"
)If that doesnt work try the second one
Measure =
IF (
ISFILTERED ( 'DAILY DATEs'[Daily] ),
"Looking at payment data between "
& FORMAT ( EOMONTH ( MIN ( 'DAILY DATEs'[Daily] ), -1 ), "MMMM YYYY" )
& FORMAT ( EOMONTH ( MAX ( 'DAILY DATEs'[Daily] ), -1 ), "MMMM YYYY" ),
"Please Select a month"
)
Hi Anonymous,
Thanks for the solution. The second formual worked form (I had to change isfiltered to iscrossfiltered) but instead of showing the selected month and the month before the selected month, the month before the selected month is shown twice. I have attached image below.
Can you suggest a fix for this?
Also including the actual formula I used, in case you wish to confirm.
Many thanks,
Gdexter
Anonymous
Problem Solved...
The "-1" in the current month line had to be changed to a "0".
Many thanks,
Gdexter