Forum Discussion

VR7's avatar
VR7
Frequent Visitor
6 years ago
Solved

MTD & %YOY in Card Visual

Hi,

 

I have dataset of number of claim submitted from client and want to show  in MTD value and YOY compare with last year number. My DAX formula result is correct in table but show blank value in card.

 

Please help in this issues,

1. Show MTD in card visual (1878)

2. Iwant to show %YOY as of today (my data as of 14/1/2020 so should show 11.26%) not show total change like this

 

Thanks in advance

 

 

 

YOY_PERCENT_GROWTH_YTD_NUMBER_OF_CLAIM = DIVIDE(CLAIMS_DATASET[YOY_GROWTH_YTD_NUMBER_OF_CLAIM],[PRV_YTD_NUMBER_OF_CLAIM])

 

 

 

 

 

MTD_NUMBER_OF_CLAIM = TOTALMTD(CLAIMS_DATASET[TOTAL_NUMBER_OF_CLAIM], 'DIM_DATE'[Date].[Date])

 

 

 

Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    In case of MTD remove .date

     

    MTD_NUMBER_OF_CLAIM = TOTALMTD(CLAIMS_DATASET[TOTAL_NUMBER_OF_CLAIM], 'DIM_DATE'[Date])

     

    Current MTD will only come when we select the month. else it will take end date of calendar as date.

    You can put a slicer or restrict max date of calendar.

    In case of YTD, either select a date in slicer of push a filter

    Example

     

    YTD_NUMBER_OF_CLAIM = 
var _max = maxx(CLAIMS_DATASET,CLAIMS_DATASET[Date])
return
calculate(TOTALYTD(CLAIMS_DATASET[TOTAL_NUMBER_OF_CLAIM], 'DIM_DATE'[Date]),'DIM_DATE'[Date] <=_max )

     

    \\Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
    In case it does not help, please provide additional information and mark me with @
    Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
    Connect on Linkedin

     

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    In case of MTD remove .date

     

    MTD_NUMBER_OF_CLAIM = TOTALMTD(CLAIMS_DATASET[TOTAL_NUMBER_OF_CLAIM], 'DIM_DATE'[Date])

     

    Current MTD will only come when we select the month. else it will take end date of calendar as date.

    You can put a slicer or restrict max date of calendar.

    In case of YTD, either select a date in slicer of push a filter

    Example

     

    YTD_NUMBER_OF_CLAIM = 
var _max = maxx(CLAIMS_DATASET,CLAIMS_DATASET[Date])
return
calculate(TOTALYTD(CLAIMS_DATASET[TOTAL_NUMBER_OF_CLAIM], 'DIM_DATE'[Date]),'DIM_DATE'[Date] <=_max )

     

    \\Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
    In case it does not help, please provide additional information and mark me with @
    Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
    Connect on Linkedin

     

    • VR7's avatar
      VR7
      Frequent Visitor
      6 years ago

      Hi amitchandak ,

       

      Thank you for your reply.

       

      Is it possible to show MTD in present month without select month in slicer?

      • amitchandak's avatar
        amitchandak
        Icon for Super User rankSuper User
        6 years ago

        In visual level filter drag the date (date used in MTD or ytd) and use relative date filter and set it to this month , today etc.