Forum Discussion

marcopete's avatar
marcopete
Regular Visitor
10 years ago
Solved

Measure for hide months without data

Hi.   Can you help me with that?    I have a chart with data from this year and previous year.   Attach image.     How I can show only the months with data for both years?    My dax ...
Need Help
Tips and Tricks
  • marcopete's avatar
    marcopete
    10 years ago

    Thanks everyone.

     

    This dax show me until i have the data, not based in data but in time and I resolved.

     

    CALCULATE(DIVIDE([Data1];[Data2]);FILTER('DIM TIEMPO';'DIM TIEMPO'[AÑO] >= YEAR(NOW()) -1);'DIM TIEMPO'[NUMERO DE MES] < MONTH(NOW()))

     

    Thanks again and all your replies are in my knowledge.

kdejonge's avatar
kdejonge
Microsoft Employee
10 years ago

 

can you share the data? I am not completly clear how your measure works.