Forum Discussion
show items with no data
Hello guys,
I´ve the following visualization:
Instead of having Mar/17 and then Mar/20 and want to see those days that i´ve no data ( this case on Mar/18 and Mar/19).
I tried the following formula:
Sales last 30 days = if(CALCULATE(SUM(FACT_INSCRICOES[PRATICANTES]);FACT_INSCRICOES[IND_LAST_30_DAYS]=1)=blank();0;CALCULATE(SUM(FACT_INSCRICOES[PRATICANTES]);FACT_INSCRICOES[IND_LAST_30_DAYS]=1))
but when apply it , instead of show the last 30 days, it show me all dates that has no data instead of show just the last 30 days that i have marked on the calculated column.
Any sugestions?
Thanks
Try just this:
Sales Last 30 Days = SUM(FACT_INSCRICOES[PRATICANTES])+0
Then use a slicer or other filter to limit your visual to only showing the last 30 days. The +0 will always give 0 if there are no sales for that day.
2 Replies
Try just this:
Sales Last 30 Days = SUM(FACT_INSCRICOES[PRATICANTES])+0
Then use a slicer or other filter to limit your visual to only showing the last 30 days. The +0 will always give 0 if there are no sales for that day.
