Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Billed All Months

Hi Team,   We have a requirement to check if a Store has Billed Consecutively All months for the last 12 Months.   I have data in the below format.       If you see the above , i have 2...
andhiii079845's avatar
andhiii079845
Icon for Solution Sage rankSolution Sage
3 years ago

Hi Anonymous ,

i try to find a solution. See this PBI File Billed All Months.pbix

Please check the PBI File. There has to be no connection between both tables. 

The measure:

Measure = 
VAR _selectdate = SELECTEDVALUE('calendar'[Date])
VAR _tb = SUMMARIZE('calendar','calendar'[Date],"_26monthpriv",dateadd('calendar'[Date],-26,MONTH))
RETURN CALCULATE(sum(sale[Sale]),FILTER(sale,sale[BillDate]>=maxx(_tb,[_26monthpriv]) && sale[BillDate]<=_selectdate))

 

 

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks!! for help, I have edited my content above. I don't need sales for the last 12 months, I need to check if the particular store has made an entry each and every month for the last 12 months