Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Smart Narrative Error: Couldn't Load Data for this Visual

Hello, I am getting an error when using a Dax to pull the previous month name into smart narrative. DAX Last Month = CALCULATETABLE(VALUES('Date'[MonthInCalendar]),DATEADD('Date'[Date],-1,MONTH)) ...
General Comment
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    I needed a previous month as text in the format of Month Year like April 2021...

    I had a formula that was working using value in visuals but not in text box as a value.

    After trying a few formulas and researching and came up with this and it dynamic value no longer gives me an error that multiple results were given when a single value was expected:

     

    Last Month Alt =
    VAR test1 = LOOKUPVALUE('Date'[MonthInCalendar],'Date'[Date],DATEADD(ENDOFMONTH('Date'[Date]),-1,MONTH))
    Return
    test1
     
    Closing this post.
v-luwang-msft's avatar
v-luwang-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ，

Use the below measure:

Last Month =
VAR test1 =
    CALCULATE (
        VALUES ( 'Date1'[MonthInCalendar] ),
        FILTER (
            ALL ( date1 ),
            MAX ( date1[Date] ) = DATEADD ( date1[Date], 1, MONTH )
        )
    )
RETURN
    IF ( test1 = BLANK (), 12, test1 )

 

 

Wish it is helpful for you!

Best Regards

Lucien

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I needed a previous month as text in the format of Month Year like April 2021...

    I had a formula that was working using value in visuals but not in text box as a value.

    After trying a few formulas and researching and came up with this and it dynamic value no longer gives me an error that multiple results were given when a single value was expected:

     

    Last Month Alt =
    VAR test1 = LOOKUPVALUE('Date'[MonthInCalendar],'Date'[Date],DATEADD(ENDOFMONTH('Date'[Date]),-1,MONTH))
    Return
    test1
     
    Closing this post.