Forum Discussion

RanHo's avatar
RanHo
Icon for Helper V rankHelper V
4 years ago

POWERBI : TARGET ON MATRIX

Good day! I just want to ask if its possible, I have problem sample here: I want to show the changes of target depends on filter months. Is it possible or is there oth...
Need Help
Show and Tell
Tips and Tricks
v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
4 years ago

Hi RanHo ,

 

In your description, which form of Date/Month is in the seperate table? By filtering Date/Month to find the corresponding sum value in the target table?

 

Looking forward to your reply.


Best Regards,
Henry



RanHo's avatar
RanHo
Icon for Helper V rankHelper V
4 years ago

v-henryk-mstf I have a table wherein the dates column located, my dates column the I want to use for filter it was separate from Target table , the MONTH column I have in Target table is just month no dates.

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

    RanHo , Create a date column using year and month in target table

    like

    date = "01-" &[Month] & "-" & [year] // mark that as date column

    date = datevalue("01-" &[Month] & "-" & [year])

     

    you can create a date tbale with Month , year etc and join to both tables and use that

     

    example

    Addcolumns(calendar(date(2020,01,01), date(2021,12,31) ), "Month" , month([date]) , "Year", year([date]), "Month Year", format([date],"mmm-yyyy") , "Month year sort", year([date])*100 + month([date]))

     

    Join with both tables

     

    and then use that as filter

     

    Part of this blog can help

     

    Distributing/Allocating the Monthly Target(Convert to Daily Target): Measure ( Daily/MTD): https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Monthly-Target-Convert-to/ba-p/1657798

    • RanHo's avatar
      RanHo
      Icon for Helper V rankHelper V
      4 years ago

      amitchandak  Okay Sir, I'll try it.