Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi guys, I made a line graph with 3 mesures: Planned Date, Projected Date and Real date. Both the mesures has the same dax code, just switching the date fields.
The code I used below is to accumulated the count from a previews date with the formula MAX:
Teste Acumulado Real = CALCULATE([Contagem Tarefas Real];FILTER(ALLSELECTED(dCalendario);dCalendario[Datas]<=MAX(dCalendario[Datas]))
What I need is when the date is < today show an empty result for that month (year and so on..)
That's the graph I m building: https://imge.to/i/g97Ur
In short I want only the red line to stop in june because that's today's date.
Thank you.
Solved! Go to Solution.
Hi @Anonymous ,
Try to change your measure to the following:
Teste Acumulado Real = IF ( MAX ( dCalendario[Datas] ) >= TODAY (); BLANK (); CALCULATE ( [Contagem Tarefas Real]; FILTER ( ALLSELECTED ( dCalendario ); dCalendario[Datas] <= MAX ( dCalendario[Datas] ) ) ) )
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi,
Try this measure
Teste Acumulado Real=IF(MAX(dCalendario[Datas])>=TODAY ();BLANK ();CALCULATE([Contagem Tarefas Real];DATESBETWEEN(dCalendario[Datas];MINX(ALL(dCalendario),dCalendario[Datas]);MAX( dCalendario[Datas]))))
Hi @Anonymous ,
Try to change your measure to the following:
Teste Acumulado Real = IF ( MAX ( dCalendario[Datas] ) >= TODAY (); BLANK (); CALCULATE ( [Contagem Tarefas Real]; FILTER ( ALLSELECTED ( dCalendario ); dCalendario[Datas] <= MAX ( dCalendario[Datas] ) ) ) )
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThank you, I tried to do the if statment inside the filter code but it didn't work.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |