Forum Discussion
Two fact tables with different granularity
Super Userkasiao , if we need add the data to first date . you can create date from month year
Try a measure like
measure =
var _min = minx(allselected(Date), Date[Date])
return
calculate(sum(Table[Existing]), filter(Date, Date[Date] =_min)) + sum(Table[New])
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Thank you I managed to get it working!
I now want to have a chart with a drilldown feature where I start with Quarters and can drill into Months.
How can I achieve that? When I try with this calculation, only Jan is accurate on the graph, for the remaining months - only sum(Table[New]) is displayed.
Thanks!
v-kelly-msftCommunity Support
Hi kasiao ，
Could you provide some sample data with expected output?
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
