Forum Discussion

punati33's avatar
punati33
Regular Visitor
6 years ago

Based on selection chart for Month vs YTD

I have a table where my data is based on Month level , for the same i am planning to generate below DashBoard   columns in table #customers Month[MM/DD/YYYY] segment   CurrentMnthCustome...
Need Help
punati33's avatar
punati33
Regular Visitor
6 years ago

Thank you Rena,

 

I  implemented the below solution by creating calendar dim , however after implementing changes i don't see YTD[ its not chaging according to the month i am selecing ] and currentmonth data displayed expecpt for January & Decemeber

 

 

Below is the DAX i am using

 

CurrentMnthCustomers =
VAR summarizedTable =
SUMMARIZE (
'Query2',
'Query2'[fns],
"CurrentMnthCustomers", CALCULATE (
sum ( 'Query2'[num_subs] ),
FILTER (
'Query2',
YEAR('Query2'[mnth]) = SELECTEDVALUE ( 'calendar'[Date].[Year] ) && FORMAT(MONTH('Query2'[date]),"mmmm") = SELECTEDVALUE ( 'calendar'[mnth].[Month] )
)
)
)
RETURN
SUMX ( summarizedTable, [CurrentMnthCustomers] )
 
 
 
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi punati33 ,

The field applied on slicer which used to filter month is from table "calendar"  or the fact table "Query2" in your report? It should be from table calendar...

Best Regards

Rena

  • punati33's avatar
    punati33
    Regular Visitor
    6 years ago

    Thank you for Quick response i am using calendar filter

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi punati33 ,

      Could you please provide some sample data in Query2? It is better if you can provide your sample PBIX file if it is convenient. Then I make troubleshooting based on the provided information. Thank you.

      Best Regards

      Rena